Search results

Could somebody give me the code for the transferdatabase docmd? I get the message that it can't find the database I want to export from. Thanks.

Convert date to string Here's my problem: On a form I need to check if there is a date in a field. It is in the long date, with time, format. When I use the IsDate function, it always returns that there is a null even though there is a date. So I thought I would convert that date into a...

How do I convert a date to a string? Thanks in advance for any help.

I have several date fields on my form. I need to check if there is a date in a field. My code is: if isnull(datefield), then... Problem is there is a date in the field but it thinks it's a null all the time. Any way to resolve this? Thanks in advance for your help.

Any suggestions on a print button right on the form. I need to be able to make changes to the data that is bound by a form and the users want the print button right on the form. The tables don't get updated since I haven't left the form (closed it yet). Has anyone run into this and found a...

Code for cancel button problem Here's my code. When the query is run that deletes the record out is when the problem occurs. That happens for a new order that is added. If the order is there and they just want to cancel the changes they made to it, then it works as it should. Query is...

I'm having a problem. I close a form in one part of my program and it completely exits me out of the system, but keeps the access lock file out there. In a different part I close a form and it works as it should, the form I came from is displayed and I am not exited out of the system. What am...

Something else on this Also, when any part of the form is clicked on the message about record locking comes up.

What's the best method for tracking down the source of my problem when getting the run-time error 3188 - Could not update; currently locked by another session on this machine. I've used the VBA debugger that comes with access but is there a way to know exactly what table or record the program...

On my form I want the user to be able to select several checkboxes at a time, like you can with a list box. Except with a listbox you have a property multi select. How do you set the checkbox to be multi select. Thanks.

I use the Microsoft flexgrid control in an access program I support and it works great. I am trying to use flexgrid in a new access program I am developing and get the message "The OLE server isn't registered. To register the OLE server, reinstall it." Why can I use it in one, but try to add...

I am using flexgrid in a form where I have to change colors depending on the line of data being output. It works great. Now I have to add a "Clear" button to the form so the form refreshes with no data. How can I force flexgrid to run with no data?

Code on OpenForm problem Function MyMsgBoxRestore(Message As String, Title As String, ButtonZeroText As String, ButtonOneText As String, FocusVal As Integer) As Integer On Error GoTo MyMsgBoxRestore_Err ' Initialize return value to -1 (for cancel) ' MyMsgBoxRestore = -1...

Form open problem I inheirited the code and the DoEvents was in there. I commented it out and the form doesn't come up properly the first time.

Form open problem I am using the Docmd.OpenForm "my form" code. Also using IsLoaded routine and Doevents.

I have a form I need opened with a message (using as a message box) when certain buttons are clicked on. When I first get into my program the form comes up as it should. Then I try it a second time and the form will not open. Anyone have this problem?

I have the code to compact a database, but what is the code to see if the database is in use? Thanks in advance.

I get how to use the RefreshLink method, but as I understand it that only refreshes the link to a new source. I need a way to reestablish a broken link. This has been happening every once in a while when my users are on the program and the lan goes down. The program resides on the harddrive...

I am using novell. I am using a Novell network.

How do I know if my user is logged onto the lan, where the backend data resides. The front end program resides on the user's harddrive and sometimes they aren't on the lan and the program gives the message that their data can't be found. Thanks in advance for any help.