Search results

I'm sorry, all I get is dinging. ?

Sorry, I used a tool called "smart indenter". I didn't realize that problems could be caused by improper indenting.

Here you go! Thank you!! Private Sub cboUser_GotFocus() cboUser.Dropdown End Sub Private Sub cmdExit_Click() Response = MsgBox("Do want to close this application?", vbYesNo + vbQuestion, "Quit Application") If Response = vbYes Then Application.Quit...

I'm working on the Login form.

I'm wondering if anyone figured out the incorrect password problem. I am trying to use this code as well, and everytime I get incorrect password...although I've verified it 100 times. Thank you!

Sorry I wasn't clear. What tool or language do I need to create the interactive customer satisfaction survey that has to include pictures of the employees that worked on the job?

Hello brilliant minds! I need some ideas for a customer satisfaction survey that includes the employees that worked the job and their pictures. Customers are to rate each employee in several areas. In addition to some basic yes/no questions about the company in general. I am stuck in my own...

SHAZAM!!! THANK YOU PAUL!!! I monkeyd with a couple of things and it is working awesomely!!! For future reference: Dim db As DAO.Database Dim strNewQueryName As String Dim oQuery As New QueryDef Set db = CurrentDb Dim strSql As String Dim varItem As String Dim txtsql...

I changed txtsql to strsql and now the query comes up blank? strSql = "SELECT *, Inventory.InventoryID, Inventory.ItemDescription, Inventory.[Reorder Level], Inventory.Units, " & _ "Inventory.TargetStockUnit, InventoryLocation.Location, Locations.LocationID " & vbCrLf & _...

Thank you for that, however I'm getting the error: Invalid SQL statement, expected "DELETE", "INSERT", "PROCEDURE", "SELECT", OR "UPDATE".

Oh one more thing, I get this error: [CODE] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. [CODE]

I'm sorry if I wasn't clear. And I did put around everything. Also, I haven't kept all of the other things I tried. I want users to be able to choose multiple values from locations [me.list] [CODE] Set db = CurrentDb Dim strSql As String Dim varItem As String Dim txtsql As String Dim i As...

Hello all! I have read too many threads I think and am now totally confused. I have an inventory table - linked to an inventorylocation table. By inventoryID. When it comes time to count, I want users to be able to choose multiple count locations. Which I use a list box filled with locations...