Search results

I made the same query using the query design. I did visually what was typed in the query. I get a warning saying "You won't be able to undo the changes this action query is about to make to the data in a linked table or tables. Do you wantto run this action query anyway?" I click yes. It...

I linked the tables twice. First, arrayTable(i).Drawing Number Temp needs to equal the drawing number in tblDrawingPhases. The same goes for Project Number. Then I took out the WHERE clause.

I have been throwing the strSQL into a text box. It gives me the same result and I throw outputs out as needed but will definitely read the information in the link

UPDATE Test Database INNER JOIN tblDrawingPhases ON (Test Database.[Drawing Number Temp] = tblDrawingPhases.[Drawing ID] AND (Test Database.[Project Number] = tblDrawingPhases.[Project Number]) SET tblDrawingPhases.[Drawing Status] = Test Database![Drawing Status];

I tried copying into a query and it gave me the same error. I put debut.print in there but I don't see a window anywhere that prints anything out

I went in and put the table in the INNER JOIN in brackets and I get an error that says "Syntax error in JOIN operation" strSql = strSql & "INNER JOIN [" & tableArray(i) & "] "

I have a database in which when it opens the main form loads and there is an On Load event for that form. It will look at the tables and for each table that doesn't start with "MSys", "~", "tbl" and "contact". This will pull the tables I need and store the names into an array. I then loop...

I go to the report and put in another control as a text box that has =[90% Check] + 14 and get #Type! as a result on the report.

I did go in the query and change the format of the expression to equal short dates but it didn't make a difference.

I went and added in the 90% Due Date control, which has the same date as the 90% check and did the same conditional formatting rules and it seems to work.

I have a query. This query is working off of a project information table. In the table the project has a phase. In the query I have the 30% check expression that says if the project phase = "30%" then make this expression equal the date in the 30% Due Date field. I do the same thing for the...

There are no other formatting rules for that control. There are other rules for other controls on the report. I made sure it was a date by putting =Format([90% Check], "Short Date") for the data.

Yes, If the date is >=Date() or <=Date()+5 it works.

I even tried putting this into the Expression Is box: [90% Check]>=Date() And [90% Check]<=(Date()+14) No matter which way I do it it will not give me dates that are 14 or less highlighted. I checked and it only goes up to dates that are 5 days or less and highlights them.

Yes. in the conditional formatting box it has Value is and then Between and I input Date() and then in the second box Date() + 14

I hate a field that displays a date on a form. I set the conditional formatting to be Value is Between Date() and Date() + 14 It would only apply the formatting for dates that were equal to the date and +5 days. I then tried Between Now() and Now() + 14 Same results I then tried Between...

I would use two but the user wants one box they can click to select the desired dates.

I have a listbox set to Multiselect property of Simple. The listbox is populated by using a table. There are 4 columns in the listbox 1 3/23/2014 4/5/2014 2014 2 4/6/2014 4/19/2014 2014 3 4/20/2014 5/3/2014 2014 The columns are PayPeriod, StartDate, EndDate...

I can't seem to find the answer to this. I saw a thread on here but it lead to a dead end. What I am trying to accomplish is the following: I have a database and one of the functions is to track the purchase of fuel. Part of purchasing fuel is registering what the current odometer reads...

Awesome! It is giving me 4 outputs per picture though. Any ideas why? EDIT- Nevermind... I had another table in the query for some reason, problem solved. Thank you very much Simon for all the help.