Search results

Here is a question, I do not even know where to begin. I have a database that helps my son and I track a collection of hot wheels cars. In the database, I have a Collection table and I have a Master List table with all the vehicles from 1968 to present. Each vehicle has a name, series, year...

Question. Why does my database populate this error when I open my form: The Mocrosoft Access Database Engine cannot find a record in the table 'tblMasterList' with Key matching field(s) 'MasterID'. But when I click ok on the error message, the database works fine until I try to navigate to...

Here is an instersting question. Either it is that unique or I havent searched for the correct things, but I havent found the answer I am looking for. I have a main form with a subform linked with CollectionID field, basically the subform is a series of checkboxes that when checked an unbound...

I am recieving the following run time error when I click the 'Owned?' check box on my form. Run-time error '3142': Characters Found After End of SQL Statement When I debug, this is what it highlights: dbs.Execute strSQL, dbFailOnError Which is part of this code string: Private...

I hope I can explain this properly: I have two tables, one (tblMasterList) which has all the HotWheels Cars made with information about each car including a check box for 'Owned'. I have a second table called tblPersonalCollection which has all of the same fields as the Master List, but it...

Hi All - I am receiveing a runtime error 438 during the following part of my code: If Not IsNull(Me.txtfilterProdYear) Then strWhere = strWhere & "([MstrProdYear] Like ""*" & Me.txtfilterProdYear & "*"") AND " End If I think its because the data in MstrProdYear is a number...

I have a form that has a subform which is based on a query, not linked to the main form. Here is the query: SELECT tblSalesDetail.SaleDetailID, tblSalesDetail.SalesPrice, tblSalesDetail.PostedVouchers, tblSalesDetail.DateTimeStamp FROM tblSalesDetail WHERE...

I have a parent form which has detailed product information, on this form I have a combobox which allows me to search for and goto a particular record, this works just fine. I have a subform which has purchase order transactions related to the particular product on it. Both the Master and...

I have a login page on my database where in order to gain access you need a user name and password. Each user name has a security level assigned to it which I would like to have dictate what parts of the database are available, I have the code working for my main form which opens after...

I have a form (frmCashSales) and I have a subform which is continuous (sfrmSalesDetails) on that form. What happens is when a product is selected and added to an order it goes from a drop down on the form into a line in the subform, users can enter as many products as they like, but when they...

I have a Form named frmCustomerList which is a datasheet view form and what I am trying to do is when I would like to edit a particular customer, I would like to double click on the CustomerID field and have it pull up in the frmCustomers so it can be edited. I found some code that seems like it...

I have a question. Is it possible to code a combobox to be visible on one form based on a condition of a checkbox on a seperate form? What I have is a main form (frmMain) and a Customer form (frmCustomers), what I want to do is have a checkbox on the customers form drive whether or not the...

I have an unbound textbox that I want to have populate the total amount in sales for one customer on the customers information page. I tried building a query and calling the result with a DLookup command and it worked for the total, but when I changed from one customer to the next it carried...

I cant seem to figure out why this error message pops up. I have used the POS database example by Bob Larson and modified it to fit my needs, but havent really changed much of the code except for some wording on message boxes and I keep getting the following error message when the form...

I am trying to get a combobox populate off of a previous combobox selection. I am receiving the syntax error: Syntax Error (missing operator) in query expression 'Products.Product Name'. Here is the code I have on the after update event of the first combobox: Private Sub...

I have an unbound textbox on a form and I would like it to show the logged in user to the databases first and last name. I have a table called tblUser where all users login information is stored, and a log in screen that runs a security level check against the table. What I would like is to...

Hello, I have a search field where the list box is populated off of a query, I want to be able to double click an item in the list box and have it bring up the details view of the record. I have the following code on the double click event based on a thread I found here, but I cannot seem to get...

Hi all! This is my first post here aside from my intro so go easy... I have a form where when I click the save button, I want all the fields to be reset to blank. I think I have figured out the save new code, but the catch is, I have 2 check boxes that when checked they disable some text...

Hello all! I am an average access user and programmer, and I have been dabbling a bit in developing a database for a resale clothing company my wife and I are running. I am hoping to find direction here through existing user posts as well as asking questions in hopes of some direction from...