Search results

Have you ever thought of having a unique value in form #2 and then link it to the form #3 using the link master/link child form properties? Also do the linking in the relationship window. Might have to add some code also.

I had to borrow my son's computer to complete my 2 Access projects since mine is in the shop. I had Windows XP and he has Windows Vista. Access 2003 now requires a security level high,medium or low. It was set at medium and then I changed it to low. I noticed it took place in both database that...

I'm trying to figure out the code to determine what drive letter will be returned. I had it about the 3-4 years ago but have not found it. TIA --CW

Yes I am already working on the replacement form. Fortunetely it does not have to much coding on it.

yes. There is a bunch of code, but the one line of opening the pricing form get's the error.

Just trying to open a form. Docmd.OpenForm "frmPricing",acNormal

Does anybody know what this is. There is no help available.

What is this error message? No help on it either.:confused:

I think I have found a solution to the problem. Add a text box that hold the text of the combobox. Column(0) has the linking ID while the Column(1) data has the text value and assigns it to the invisible textbox. After making using the cbobox, make it invisible and make the textbox visible.

Sorry. Was just trying to help.

Make a reference to the Microsoft.Excel. Here's my spreadsheet code: Public Sub PrintToXLS(strQryName As String, strTitle As String, intDataStartCol As Integer, Optional intDataStartRow = 2) On Error GoTo err_trap Dim xls As Excel.Application Dim wb As Excel.Workbook Dim myRange As Excel.Range...

I been having trouble linking my data together. For the main form and subform: Master Field:RoomID Child Field:RoomID Table Linkage: TableNames:Accessories.AccessoriesID to AccessoriesLI.AccessoriesID TableNames:AccessoriesLI.AccessoriesLineItemID to...

What are you doing? That code that I gave you is the only thing that you need. Nothing else. Throw it away.:confused:

I figured out a different way to do it. Thanks!

Re: Importing data - browsing for file(New Easier Way) Add a reference to Microsoft 11.0 object code in the Tools,References. Here is the easy way to do it: Dim dlgOpen As FileDialog Dim sLogoPath As String 'Open a dialog box and get a filename for the data database. Set dlgOpen =...

I am trying to pass codes from a menubar to a password form. All of these forms need to be validated first by using a password protected form. I have the password form already built, but all the forms need to use it and then go off on the form each needs to go to. I just did not want to build a...

***This requires a reference to Microsoft 11.0 Office Library*** Dim sConxString As String 'Open a dialog box and get a filename for the data database. Set dlgOpen = Application.FileDialog(msoFileDialogOpen) With dlgOpen .Title = "Open an Access database to connect to"...

I was getting the same problem about 2 months ago for me. First, copy your data to a different storage place, such as USB memory stick. I had to buy a new hard disk because my was failing. It would'nt even boot up at the very end. I had to take it in to a hardware store where to got me a new HD...

Make sure you have the form which will show the results. Have the results form refer to the forms recordsource. Second, the input form should not refer to anything. Just have your comboboxes set to list the cities in the table that you already have for by using a combobox. Third, make sure...

I also use comboboxes for using criteria. You should also use continious forms on your form properties if your not using them yet.