Search results

Have you taken a look at the built-in Resource Scheduling database that comes with Access?

try this... UPDATE tblA INNER JOIN tblB ON tblA.ID = tblB.ID SET tblA.Name = [tblB]![Name] WHERE (([tblA].[ID]=[tblB].[ID])); :)

Hth SELECT tblTesting.RowA , tblTesting.RowB FROM tblTesting WHERE (((tblTesting.RowA)=[RowB]));

subform? Have you considered doing this with a subform? That way you could just navigate thru your test records, and would automatically see all the related details for each one, without having to click any command buttons. To do this [test with copies first], put the main form in design...

Bad reference... I got it to work, you have a bad reference to ActiveX library, no tot mention other errors in table design, etc.. Not sure if this is the resiult you wanted, but the report now generates properly. Copy of corrected db attached. HTH :cool:

ImportErrors You should get any errors or lost data in a system generated table called "tblName_ImportErrors", which will show you exactly what was lost. Was such a table created?? :confused:

1) Is the db always running? If not, how will it run wihen the db is closed? 2) If you have the code to send the e-mail in place, then you need to set a timer event that will run, oh, every so often, maybe once a minute, or once an hour, if the system date/time equals the fieldvalue...

Like this?.... Assuming your table is named tblMain, and the field you want to update is called 'Dollars', then on your form and in the code behind the update button: '************************* Private Sub Command0_Click() Dim strSQL As String strSQL = "UPDATE tblMain SET tblMain.Dollars =...

Maybe like this... I haven't tested. [spaces added in statement for clarity] DLookUp("[UserDepartment]","UserList","[LoginID =' " & CurrentUser & " ' ] " ) HTH :o

ghudson: Don't see why not but really don't know. Beleive I found thsi on the FMS site... here is more info... Tip #2: Using the User Roster to Check for Users in a Database Provided by : Troy Munford, FMS Development Operations Manager Version 4.0 of the OLE DB Provider for Microsoft Jet...

ooops, my bad :o the first apostrophe goes BEFORE, not after the first middle quote... should be one before and one after the middle set of quotes.

Try this... strsql = "Select * from Master where Technician_Name = "' & str & "'; " Added two apostrophes, one after and one before your middle set of quotes. Haven't tested, so not SURE if this works. ;)

sorry for the delay... Yes, you need to open the Immediate Window to see the results. Open any code behind form or module. Then click on the View menu, then Immediate Window. You will then find your results. ;)

update query You should be able to do it with an update query. FIRST, DO THIS ONLY ON A BACKUP COPY OF YOUR DATA TO MAKE SURE IT WORKS AS EXPECTED. For example, assume a table called tblLink with a hyperlink field called Link. And, assume that you have a value in the field of...

Take a look: :cool: http://support.microsoft.com/default.aspx?scid=kb;en-us;285820&Product=acc2003

references? Check under the VB Tools menu for your references. Make sure that all references required are checked... possibly VBA for this function.

Can't you simply increment the bad days field each time it is appropriate? Add a new field to your table called BadDays, or something similar. Increment that field each time a day should be added. Add that value to your date calculation. no? :o

If you must... There is really no point to trying to keep your autonumber field values sequential, but if you must... Do this only on a backup copy of your data to make certain it works as expected. This also assumes that that autonumber value is NOT participating in any relationships... if...

OK, what do you want to know...? Question not clear on what you are trying to do. If you want to add the new data to the form that you are now incorporating into your new query, very easy. Mostly a design issue. How do you want to display this new data? Many choices... listbox, combo box...

see if this helps... http://www.experts-exchange.com/App...Q_21091452.html http://www.experts-exchange.com/App...Q_21027236.html http://www.experts-exchange.com/App...Q_21047513.html :cool: