Search results for query: *

neither one are primary keys.

It's a relatively small database created to generate Bill of Materials. The database has not been split. All the data is in a single .accdb file except for a single table [tblPartsTemp] on a SQL server.

Getting error 3027 and can't figure out why. Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Set db = CurrentDb strSQL = "SELECT tblBOM.PolyUOMcost, tblPartsTEMP.CurrentCost " & _ "FROM tblBOM " & _ "INNER JOIN tblPartsTEMP ON tblBOM.PolyID...

Thank you so much for the help. It works perfectly now.

I'm pretty clueless at this stuff, but I've managed to put together a query (just can't manage to make it work). Any suggestions would be greatly appreciated. strSQL = "SELECT DISTINCT tblContractDetails.ContractDetailsID, tblGradingSheet.ContractName, tblGradingSheet.Source" & _ "...

I would have never even thought of that... Thank you very much Skip Problem solved. Loyd

I can't... I've tried to get to the vba window, but the userform has the focus and I can't do anything. Tried opening additional spreadsheets to see if I could get to the form by using a different workbooks vba window, but as long as the userform is open it has the focus and I can do nothing...

Skip, The problem is that I never completed the userform. The buttons on it have no code behind them. I realize it was a really dumb thing to do, but it's done and I can't figure out how to get around it. The userform cannot be closed either by the "x" button or by any controls on the...

No dice... Thanks for the suggestion Tom. Loyd

Is there some way to open the spreadsheet without executing the code in the workbook's open event?

Basically a login window. Certain sheets would be made visible based on a username and password. It is actually not needed at all and does get in the user's way. At this point I would like to make it all go away, but I am stuck. I cannot get to the data because of the userform. If I could just...

It doesn't work. The code that I used to disable the "x" button apparently traps this also. Private Sub UserForm_QueryClose(Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True MsgBox "Please use the button!" End If End Sub I appreciate...

I've gotten myself into a fine mess here. I have a very large spreadsheet that I've been working on for a couple weeks now. I was trying to use a userform to show certain sheets based on a user login. I know nothing about vba so I've been reading and getting snippets here and there. What I ended...

I've probably looked at a hundred of your posts to help sort out problems. As always, you have the answers. Thanks PHV...

I can't get the following to evaluate correctly varTI5 = Nz(DLookup("TimeIn", "tblTimeCard", "Employee = '" & Me.Combo6 & "' AND DateIn = #" & varThuDate & "#")) Me.txtTI5 = IIf(IsNull(varTI5), "", Format(varTI5, "short time") & " " & Format(varThuDate, "mm/dd/yy")) Whether varTI5 is...

Thanks Tom..

I have several excel spreadsheets that I append with a query in Access 2003. I went into Options-Edit/Find and unchecked confirm action queries box, but I still get an annoying pop-up informing me that I am about to make changes to data in a linked table. "You won't be able to undo the changes...

Works like a charm. Thanks PHV...

I've managed to do what I set out to do. I am having a problem though. The code executes perfectly only every other time. I get the following error every other time the code executes. Run-time error 9 Subscript out of range It occurs on: Workbooks("Multiplier.XLS").Close...

Sorry to take so long getting back... Dim appExcel As New Excel.Application Dim strPath, strPath1, strPath2 As String appExcel.Application.DisplayAlerts = False strPath = "C:\TTDDB\Pricebook\Multiplier.xls" strPath1 = "C:\TTDDB\Pricebook\TotalCost.xls" strPath2 =...