Search results

just wanted to let you know in what i emailed you, there is no form at all, i need it created.

I have an inventory database i am working on but am too new to access to know all the inner workings. Quick summary of what I need to accomplish: I have a databse with several tables each representing different types of parts that we sell. Each table is similar in that the primary key for each...

RuralGuy, check your PM's

yes, and i have saved it with every button i see.

I now get an error that says "Expected: identifier." instead of the "Expected: list seperator or )."

I attached the first error i get and then after clicking oki get the box that says "the text you entered isnt an item in the list" ,"select an item for the list or enter text that matches one of the items in the list" I get no option to add it to the list. I posted the pic b4 so you could see...

i just changed it to yes, but am still having problems. Heres is the code:

in the visual basic view i have: Option Compare Database Private cboCombo65_NotInList(NewData As String, Response As Integer) On Error GoTo cboCombo65_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The job title " & Chr(34) & NewData & _...

Thanks man. I was able to get it to add the part number to the list but it doesnt prompt the user at all, nor does it take you to that record like i need it to. I also am looking for it to clear all the other fields on the form when doing this to clear it for entry of the new part number with...

I have an access 2007 database with a combo box that is filled with part number (which is also the uid) from its corresponding table. when you enter a part number that is already a record and then Tab out of that field, it takes you to that record, but when you enter a part number that doesnt...

well in my instance, the tallied values represent used parts and their condition. there might be 3 "like new" parts, 2 "rusty parts" and 4 "new in box parts" that all share the same part identification # for a total of 9 parts, this data will be exported to quickbooks which only supports a...

alright i was able to do it wit: =Val([LINE 1 QUANTITY])+Val([LINE 2 QUANTITY])+Val([LINE 3 QUANTITY]) but I need this calculation to also be stored in the table.my other problem is that if any one of the 3 totaled fields are blank it says error and and also if all three fields are blank it...

I have a table where there each record has 3 fields i need to add together for a fourth both in my form and the table and i need the data in that field to be uneditable. how might I accomplish this? In the control source i tried: =[LINE 1 QUANTITY]+[LINE 2 QUANTITY]+[LINE 3 QUANTITY] but it...

thank so much!!!

I'm not sure how to incorporate this, sorry im a newb

yes to both. I noticed one line says: on click: [Embedded Macro] do I need to change the macro and if so, how?

i am on access 2007 and my properties on the right are different and there is no record source line that i can see.

I have inserteted the next and previous record navigation buttons into my record entry form, my problem is that they go to the records based on the order they were entered and not based on the alphabetical part number list i have set for the unique identifier. Because new part numbers are...

okay, took care of that, but is there a way to make it tell you the part number already exists before proceeding to the next field in the form? The part number is the first field and there are 25 more after that and it would be a real pain to fill in all those fields only to find out its already...

I have a fairly simple database we are using for keeping inventory and new items get added through a form. Is there A way I can prevent a part number and its properties from being entered if that same part number has already been entered at an earlier point in time?