Search results

Conversion Error I have an existing table in Access. I am using the DoCmd.TransferText to import it. It seemed to be working ok. I added a DoCmd.OpenQuery before it that will delete all the data from the table. Then the DoCmd.TransferText runs. However, I get a type conversion error on two of...

Date problem importing from csv Ok. I have given up on SQL Server. I do not know enough about it to get this done in time. I am trying to import a csv file into an Access table. The first column is a date. However on the csv file the date reads 21706. I get an error table. This is the only...

Excel to SQL Hi everyone. I have a .CSV file that I am importing into a table. I cannot get the date to convert on import. It creates June 5, 1959. I am trying to create a function on data transformation. I am close but I can't quite get it to work. In tblUnitImport.DelDate is datetime. Here...

I am importing an Excel file into a table in SQL Server that was created by an AS400 program. I linked this table in MS Access. The date fields from the SQL Server table are split out. DSREQM is the month and day. DSREQY is the year. When opening the table it looks like this: DSREQM...

As400 I need help with this also. Did anyone ever answer you?

I have a query that pulls all orders out of 3 tables that fit specific criteria. tblLotInfo.WOSD = Between ([tblLotInfo].[WOSD])<=Date() And [Forms]![frmRaisedPanelLots].[EndingDate] tblDelivery.Status = <>"On Floor" And <>"Floor Hold" And <>"On Floor LV Losee" And <>"On Floor LV N. 5th" And...

I have a report with to subreports. The subreports are not visible. I have a text field that states...

I am not sure if this is possible, so if anyone could help I would really appreciate it. I have a table tblLotInfo. There is a LotDelDate(Delivery Date) and ReDelDate (Redelivery Date). There is a history table tblHistory where the ShipDate, ReturnDate, and ReShipDate are located. In my query...

As far as I know, you will need to create two queries. One for 1 date and one for the other. You can then use those queries to create a report. You can design a report and setup to subreports within that report based on your two queries. Or base the report on 1 of your queries and add a...

Please HELP!! Does anyone have any ideas? I have tried several different things with no luck. The form is pulling the information from a temptbl that is created when a make table query is run. So there are not a lot of records. I don't understand why it is so slow.

I am also wondering if there is anyway to do this outside of a form. Basically we want to take all the customers that are a priority (whatever number is selected) and move their delivery dates back by so many workdays.

I'm wondering if anyone has any idea how I can speed this form up. I have similar forms that don't calculate as much but are much faster when updating the date. Basically, I have a make table query that pulls all units due to be delivered between a certain time period, that are a specific...

I have a Department status report that each of our department uses to determine in which order to process our cabinets. Management would like to create a form based on this report, so that it is listed in the same order where the user could click a checkbox on each job that was completed. When...

Ok. I think I have this figured out. I added an unbound field to the frmDates. Each time one of those date fields is updated it populates the unbound field CurrentStatus with the correct status. I created a module that takes the information in CurrentStatus and put it's in the...

Thanks for replying back. But I am getting an Object required error 424 with this. It highlights If Me.Production Is Not Null Then This whole form is dates throughout the plant. Production Sander Prefinished Assembly Paint Floor ShipDate InstallDate So, for instance when a production date...

I have a form called frmSpecificDelivery. A user access this form to look at delivery information for each job. On this form is a command button called History. The user clicks this and opens a History form where they enter dates as the job travels through each department in our manufacturing...

I still can't get it to reset back to NewDate. I can't figure out why. I have tried Me.NewDate.SetFocus frmSpecificLotHist.NewDate.SetFocus Me.[NewDate].SetFocus

I tried your code. However, I still can't get it to reset the focus back to the NewDate field. Private Sub NewDate_AfterUpdate() Dim VBAnsw As String If Format(Me.NewDate, "ddd") = "Sat" Then VBAnsw = MsgBox("You have a chosen to deliver on a Saturday! Are you sure?", vbYesNo, "Scheduling...

I am trying to notify users if they schedule a delivery on a weekend. I have the code below. However, it doesn't set focus back on NewDate. It skips ahead to Comments. What am I missing? Private Sub NewDate_AfterUpdate() If Format(Me.NewDate, "ddd") = "Sat" Then If MsgBox("You have a chosen to...

I was able to get the running totals I need to by adding an IIF statement in the query. However, I have another problem. They need to see Sat dates as well. Even though currently there is nothing scheduled against them. Saturdays are our makeup days and we try to catch up a little. So we want...