Recent content by brucewalker

The record source for the form is a query based on three tables. Yes I have closed and re-opened the form. I think the problem is related to the fact that one of these tables originally contained all the data related to custoer orders. I used the table analyzer to split the main table into...

I need to append records from a table to three other tables. I imported the spreadsheet into my database and then created a query to pull the fields I needed from the imported table in the query. The query pulls records for fifiteen different fields. I then change the query type to an append...

Paul, It worked perfectly. Thanks very much for your help.

Paul, When I pasted it into the SQL view it put them there. I did remove them and wit the brackets around the table name the query ran. I did find an error on my part though in the date format. The date is actually format as dd-mm-yy not mm-dd-yy as I originally communicated. My apologies for...

Paul, Thank you for your assistance. I really apprectaite it. Yes I have created that field in the table with the proper data type. When I add the square brackets as below, I still get the same error. Does the TempDateField name have to have brackets as well? "UPDATE [Copy Of Parts...

Below is what I pasted into into the SQL view of the query. "UPDATE Copy Of Parts shipped 2001 SET TempDateField"=DateSerial(Mid([PRCDTE],7,2),Mid([PRCDTE],1,2),Mid([PRCDTE],4,2)) I suspoect I have done something wrong because when I try to back to design view I get the following error...

Paul, Thank you. I have a follow up question. If I create an update query do I need only the two fields, being the one with the mm-dd-yy format and the tempdatefield? Also do I put the code into the "update to" line of the query in the tempdate field? Thanks.

I have a table field that is set to text, but contains a date in the mm-dd-yy format. How can I change this to a short date format? Thanks.

I have a parameter query which opens a form. The parameter asks you to enter a start date and an end date. I want to add a message box which pops up and will say you must enter a date if the user clicks ok without entering the requested date. How can I do this? Thanks.

I have a combo box in a form to choose from a drop down list. When a valus is chosen from the drop down list I want to insert the date into another field on the form. How can I do this? Thanks.:banghead:

I am looking for code I can use to prompt for a password when opening a form with a command button. I want to restrict who can open this form and I can t seem to find antythig that works..:banghead: thanks.

I have a switchboard in in which I have a command to open a report, one to open a table and two that go to other switchboards. when I added the last go to switchboard command which is titled Reports, it changed the header on the main switchboard to Reports as well. However if I open the main...

I have a combo box on a form that has drop down list from a table. Is it possible to add additional items to the table through the combo box so I don't have to first add it to the table and then acess it through the combo box? as an example let's say the drop down list has; apples oranges...

I am new to this forum. I know just enough to be dangerous with Access so I will probably looking for a lot of help. I live in Tennessee in the US and work for a company that services the heavy trucking industry. I look forward to being active on the forums. Regards.