Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: michaelhutcheson
- Order by date
-
Append a range
You have solved it!!!!!!! Thank you so much for your help, you have made my day : -D- michaelhutcheson
- Post #20
- Forum: Microsoft: Access Forms
-
Append a range
I'm lost. When I use the FROM statement I receive the message "Characters found after end of SQL statement" and then it highlights the FROM statement.- michaelhutcheson
- Post #18
- Forum: Microsoft: Access Forms
-
Append a range
for your first one I received: The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.- michaelhutcheson
- Post #16
- Forum: Microsoft: Access Forms
-
Append a range
Even just appending the serial number's doesn't work: INSERT INTO tblSerial ( SerialNo ) SELECT [tblNum]![Serial] AS Expr1 WHERE ((([tblNum]![Serial]) Between [Forms]![frmSerial]![qryMinNum subform].[Form]![MinOfSerial] And [Forms]![frmSerial]![qryMinNum...- michaelhutcheson
- Post #14
- Forum: Microsoft: Access Forms
-
Append a range
I've tried this append to no avail: INSERT INTO tblSerial ( [Date], Part, SerialNo ) SELECT [Forms]![frmSerial]![txtDate] AS Expr2, [Forms]![frmSerial]![cmbPart] AS Expr3, [tblNum]![Serial] AS Expr1 WHERE ((([tblNum]![Serial]) Between [Forms]![frmSerial]![qryMinNum subform].[Form]![MinOfSerial]...- michaelhutcheson
- Post #13
- Forum: Microsoft: Access Forms
-
Append a range
I've chagned the names for code example but can't seem to get it to work. I amended the SQL statement but keep receiving the message "Characters found after end of SQL statement" and then it highlights the FROM statement. Sorry, Access is not my strong point!- michaelhutcheson
- Post #12
- Forum: Microsoft: Access Forms
-
Append a range
Ok, I have a table called Num that holds numbers from 10000 - 99999999 or however many and also has a yes\no field called 'taken' Then I have the below form: Date: [ ] User enters the date Part: [ ] This is a look up from a table that is linked to our ERP system Serial: [ ]...- michaelhutcheson
- Post #7
- Forum: Microsoft: Access Forms
-
Append a range
mmmm I don't fully understand I'm afraid. Where do I put the DMax formula?- michaelhutcheson
- Post #5
- Forum: Microsoft: Access Forms
-
Append a range
the serial number is based on the qty. so if you choose a qty of 1, it would the serial number would be 1. then the next user enters a serial of 10 the serial numbers would be 2 - 12 etc- michaelhutcheson
- Post #3
- Forum: Microsoft: Access Forms
-
Append a range
Hello, Is it possible to append a range of numbers to a table? For example: 3 fields - Part, Qty and Serial No. User selects a Part and enter a qty, eg Part: ABC and Qty: 10 Then I need access to work out and append the Serial number and the Part and Qty. However, the serial is based on...- michaelhutcheson
- Thread
- Replies: 19
- Forum: Microsoft: Access Forms
