Recent content by CraigWarmy

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 =...