Recent content by cstaab

I have connected to a Lotus Notes database via ODBC within my code. The problem that I am having is within my SQL to query back certain records. This is the SQL that I am using: DoCmd.RunSQL ("INSERT INTO tblMain ( City, DateCreated ) SELECT CustomerIssue.City, CustomerIssue.DateCreated FROM...

I am trying to import a lotus notes table into an access table. I can do this correctly by hand by selecting File-Get External Data - Import. However I cannot seem to obtain the correct code to do this process automatically. Typically I would do it by hand each time, however with the large...

I just realized that I switched forums and I gave you the code that I have for an Excel Spreadsheet. It may work but I'm not sure. Sorry for the confusion.

Here is a little piece of code that I used to connect automatically within a macro. You can play around with it and see if you can custom fit it to fit your needs. ConnectString = "ODBC;DBALIAS=DBP01MUF;UID=" & UserID & ";PWD=" & Pwd & _ ";DSN=DBP01MUF" Set wrkODBC =...

In design view, right click on the button and select properties. Click on the events tab. Click in the on-click event area. Click the elippse (...) and choose code builder. Put the code within this macro.

Put this code in the button: textbox.value = date() Cody

I found a piece of workaround code that brought up a "browse" window and the user can path to the file that they want to hyperlink to and then put that value in the hyperlink textbox. If anyone needs this code let me know.

In the table, go to the properties of the field in design view. There is a property called "Allow Zero Length". Set this to no and let me know if that works.

I have a form to open up in PopUp mode. When you are not in PopUp mode and you right-click on a hyperlink field, go to Hyperlink>, and then Edit Hyperlink... Here you have the ability to use the browse option to path to the file you want to link to. However when you set the PopUp property to...