Search results

I am trying to update a table called employees. The field I am trying to update in the table is called Notes. It get's the information from a text box on the form called Me.[Notes] Here is my code: DoCmd.RunSQL "UPDATE Employees SET [" & Notes & "] = Me.[Notes];" And idea's on how to get it...

I sure did. Thanks for the follow up.

I ended up using the docmd.runsql delete command. Does what I need. Thanks for the reply.

I am trying to delete a record from a table called employees. Inside my form, I have a drop down that is linked to the table. When you select an employee in the drop down and click the delete key, it delete's the top record and not the one selected. Any idea's?? Here is my code...

Hi Wayne, Thanks for the reply. What I ended up doing was: Dim Line(255) Open file for input Do While Not EOF(1) x = x + 1 Input #1, Line(x) Loop Close #1 It allowed me to put everything in an array and use it.

I have noticed that the data does read in. How do I pull it out?

I have a text file in the following format: lastname firstname middlename employeenumber hiredate etc... I have a combo box with a dropdown of all the employee names. When you select a name, it opens the correct text file and should pull in the information. I am getting a runtime error 62...

sub test_click () Dim WSHShell Set WSHShell = CreateObject("WScript.Shell") WSHShell.Run("C:\Hallo.bat") end sub

Can someone tell me how to shell out the a .BAT file under Outlook VB?? I can get this to work correctly under MS Access VB but cannot seem to figure it out under Outlook. Thanks, Greg

What I am trying to say is that my ID field does not match up with the record field on my form...

I have a table that I have entered in information from the form but decided not to save it. It still counts up the record number but the ID is not the same. IE: viewing the data in my table displays ID's 1-259. But I may be missing ID's 20-25, 30, 240-245 etc. So when you use the dcount...

I have a form that displays the activex calendar and has a list box on it that displays your holidays. I would like to click on one of the dates listed in the list box and have the calendar change to it. Also - how can I get the calendar to gray out more than 1 day?? Ex: I have a holiday in...

If DayName = "Saturday" Then Me.[Return Date1] = DateAdd("d", -1, Date) If DayName = "Sunday" Then Me.[Return Date1] = DateAdd("d", 1, Date) Needs to be If DayName = "Saturday" Then Me.[Return Date1] = DateAdd("d", 2, Return Date1) If DayName = "Sunday" Then Me.[Return Date1] = DateAdd("d"...

I have a log that auto signs a return date from a selection. If you select a week it just adds 7 days to the current date If you select a month it just adds a year to the current date If you select a year it just adds 7 years to the current date. I have it check to see if the return date is on...

Found this code and it works great under Access 2000. Create a command button with the following code: Dim repMaster As New JRO.Replica repMaster.ActiveConnection = currentproject.connection repMaster.Synchronize “C:\Path to replica”, jrSyncTypeImpExp, jrSyncModeDirect End Sub...

I changed the properites on the form: popup to no and model to no and it works again... Not sure why...

I have by database setup to replicate and it works great. What I am trying to do is create a command button that will allow you to replicate on the fly without having to close the form down and select tools then replicate then sync. Anyone got any good code that works? I have tried just about...

I have been using the GoToRecord within VBA up till today when it started giving that error message...

I am receiving the following message: You can't use the GoToRecord action or method on an object in design view. How can I get out of design view?

I have a command button that when pressed by 'user x' will open up a popup screen and display his entries from the table. Atleast this is what I am trying to do. Any code ideas on how to do this? I do not want to use a query if I can get around it.