Search results

I have a print button on my form using the following code to print a single record report: Private Sub Command26_Click() Dim strDocName As String Dim strLinkCriteria As String DoCmd.RunCommand acCmdSaveRecord strDocName = "InventoryTagBusway" strLinkCriteria = "ID = Forms![BUSWAY]![ID]"...

I have searched and found countless threads for how to print a single record being being viewed on a form to report but none of them seem to be working for me, it still keeps printing ALL records. I have attached a simple sample database of what i'm working with, it has a table, a form, and the...

I am confusing myself more and more as i read on normalization and queries and everything else. I am trying to create a database for parts that our company sells and am having trouble deciding how to lay out the tables. I figure I should use the part number for the primary key as it will not...

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...

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...

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...

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...

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?