Recent content by jordankoal

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