Search results

same problem I encountered the same problem but am having trouble implementing the code. On the line : Set dbExternal=wrk.Database("name of database including path", _ False, False, "") I keep getting the same error with my code: Set dbExternal = wrk.Database("C:\Documents and...

ok Here is the type of code I am using. Whenever I split the database the code has problems. It comes up with the error data-type mismatch. There are no problems when the database is not split. Here is the code: Dim ThisDb As Database Dim ProdList As Recordset Dim Lookfor As String...

I had written alot of code in a databade using DAO instead of ADO. The code does alot of of opening of tables looking at data and then setting data = to the lookup data. This works great until split the database. And I think switching to ADO will let this work. Is there any book or online guide...

On a form I have a combo box with three columns. The three columns are as folows; the bound column is the driverID, and the next column's are driver first name and driver last name respectively. When someone selects something from the combo box, I wanted the driver ID of that driver selected to...

I have a report which gets crtiteria from a form. The form sends the driver # the person picks to the reportand it is filtered by driver. This driver number is sent to a combo box and in turn the combo box shows the correct driver name. I hide the bound column so that only the driver name shows...

It doesn't matter It is hard to explain, but it works if I can get that one piece of data to be sent back to two tables. Does anyone know how to do it?

bump bump

Because I need a history record, so I can check for exceptions, like if an item was checked out but not back in, and I need an updating record of the status so they can use a report to show where the item is at the present moment.

I have two tables linked by a ItemNumber. One table is a history table, showing everytime an item is checked in or out. The other table is an updating table no new records are added, all that happens is when an item is checked in or out, the record for that ItemNumber updates the status to in or...

Is there anyway to automate my update query, so that when I leave a form the query runs automatically in the background? And is fully automatic?

Better explaination Ok, I think I need to give a better explaination. I want on the after update property of a form, for a function or something, to match the ItemNumber that was just entered in the form, to the same ItemNumber in a table and for it to change a the Status field to what was...

The deal What I need is this: I have a subform that needs to send a single value to two tables. I need the form to lookup the Item Number of the item that was entered on that line and change the Status field in two tables by looking up the item number and changing the value to the one that was...

I have a form and a subform. The field "Status" is filled in on the subform for a certain "ItemNumber", and I need the status that was entered there to be sent to the Status field of 2 tables. one Being the "Item File" the other being "Item Subform File". Can this be done with the DLookup...

I have a field on my form, that needs to always be capitalized. If some one enters "in" I need it to automatically change to "IN", when they tab out of the box, so an after update event. How can I do this with the UCase() Function? Or by any other means?

I have a Main form with one subform on it. The subform is in datasheet mode, so it can have multiple things entered. You know you go into the first field and then another blank line pops up. However, when I am using the SetValue function in a macro that extra line does not pop-up, I guess the...

I have a form that has one subform. On the form there is a box called itemnumber, and there is also the same field on the subform. These fields are going back to different tables though, and I need both values to be the same. I need the itemnumber field on the main form to equal the itemnumber...

How? How can you have it lookup the record and edit it? Without a human person going in and doing it manually?

Quick question. How can you set the value of a text box to the current date? So that you don't have to enter the date, it does it automatically when you open the form.

Here is the SQL SELECT [Toll Expenses].[TRANSACTION DATE], [EZ PASS Toll Query].AMOUNT, [IL TOLLWAY Toll Query].AMOUNT, [IPASS Toll Query].AMOUNT, [OH TURNPIKE Toll Query].AMOUNT, [OTHER Toll Query].AMOUNT, [T-CHEK Toll Query].AMOUNT FROM ((((([Toll Expenses] LEFT JOIN [EZ PASS Toll Query] ON...

Problem When I do this, I keep getting duplicate dates in the query for some reason. I don't know why. It repeats dates and amounts in the final query for no reason.