Search results for query: *

Good Morning, Is there a way to disable Quick Access Toolbar so that users can not add commands that allow them to access the design of forms/reports or data (delete)? Thank you.

Good Morning, Is there a way to disable Quick Access Toolbar so that users can not add commands that allow them to access the design of forms/reports or data (delete)? Thank you.

Hello everyone, I have an Access 2003 adp and connected to SQl2005 server. It has been running fine but the last few months, I received a lot of message "Connection Failure" and I basically have to end task the database and restart it. I have checked the SQL server and the Access database and...

Hi Everyone, I have a Main Customer form with a button when I click it, it will open another form, with code something like this when button is clicked: stDocName = "frmCustomerBillingInfo" stLinkCriteria = "[CustomerID] = " & Me![ID] DoCmd.OpenForm stDocName, , ...

Hi All, I have a table like this ID Item RcdCount 02 x 02 y 02 z 05 a 05 b 04 j And I want to update it to look like this ID Item RcdCount 02 x 3 (Because there are 3 records of ID 02) 02 y 3...

Hello Everyone, In an ealier post, I have 2 tables as below: tblOrder OrderID Item Unit Match 01 Book 2 01 DVD 4 01 Games 3 02 Book 5 02 DVD 6 03 DVD 7...

Hi everyone. I have a table tblOrder OrderID Item Unit Match 01 Book 2 01 DVD 4 01 Games 3 02 Book 5 02 DVD 6 03 DVD 7 03 Games 8 I want to...

Hello everyone, Let say I have these several tables, tblCustomerTransaction, tblCustomerShip, tblItemsType, tblItemsCost as follow: tblCustomerTransaction ID Item Orderdate Unit UnitCost 02 Tool 01/01/10 10 02 ToolKit 01/01/10 10 02 Electro 01/01/10 5 05 Games 01/01/10 2...

Hi Everyone, I have a table with a field that has null value that I wan to update. Let say I have a table tblCustomer: OrderID Customer# CustomerName 10890 2234 John Smith 10890 Null John Smith 10890 Null...

Hi, I have two tables tblData1 and tblData2 with 3 columns Id, First, Last, on both. tbldata1 is the full table and tbldata2 consist of selected records of tbldata1. Now I need to filter all the data out in tblData1 that are in tblData2. for ex: tbl1 tbl2 1 3 2 5 3...

Hi, I am not sure I post this in the right forum. Here is the problem I am facing: I have an Order form that have records group by an unique order#. Whenever I select by double clicking a record, the entire set of records with the same order# will be copy into a temporary SQL table...

Hi, I have a MainForm which has 2 subforms in it. namely subForm1 and subForm2. In subForm1 I have several hundred of records and when I double click on one of the record, it then highlight that record selected and display the detail of that record in SubForm2. My problem is when I scroll down...

Hi everyone, I have a table with 4 columns, namely customer,price1, price2, price3. how can I find the maximum price for each custom. Here is an example of my table: Customer price1 price2 price3 john $3.00 $2.00 $1.00 john $6.00 $3.00 $4.00...

Hi All, Let say I have a SQL table named tblSPcodes in which all fraction numbers are stored as text like this: SCode 255.20 332.01 227.1 732.10 When I export this text column to Excel it will make it look like this SCode 255.2...

Greeting, Using Conditional Format, we can color a record when an expression is met. What I need to do is very similar situation except when the expression is true I need a textbox to be visible for that row. Visually: Mary Smith 11234567 $40.50 not checked(chkbox) John Dow...

Greeting, TheAceMan1 once showed me how to run command to insert a record into SQL table. I implemented and the codes ran fine. Now I have a very similar process that is attached to a different control, and when I run it I get a "run-time error '3': Closing delimiter not found for the string...

Hi, I created a table call tblFileHeader and from Access adp I ran some code and inserted several records for testing. Now I want to delete completely the table and redo it but everytime I try to delete it , I have error saying "Cannot drop the table 'dbo.tblFileHeader' because it is being used...

Greetings, I have a main form where there are users info, and a button when click it will open a second form named Vehicledata. These forms are link with userid. My problem is when I click to open the Vehicledata form, I can add the first record fine into the Vehicledata form, but then when I...

Greeting, What I am trying to accomplish is I have a form that users enter their information and one of the text box is for Social Security number. I want to make this box in a way when the user enter the first five digits it would shows "X" except for the last 4 so that their sensitive info is...

Greeting, I have a label in a form where I attached a Hyperlink address in its properties. When I click the link, I notice in my browser, at the end of my URL, it added http://...FirefoxHTML\Shell\Open\Command. as a result of this, it gives me an error 404 File not found. Is there a way for me...