Search results

I have my data merging to a word template. I am looking to add a field to the form that if ProductYesNo(Checkbox) equals -1 then put ProductSN here. I cannot get this to work. Any help would be greatly appreciated. Thanks.

yeah but thing is I do not have a field just called laptops. I have a field called device_type that has laptops and desktops in it.

I want to create a report from a field with pcs and laptops to only report laptops. Both are coming from a fied called Device_Type in the database. Is this possible with an if statement or something. Thanks.

Thanks for the help. I figured it out by pasting the following in the source code of the field. =DLookUp("device_type","inventory","serial_number = '" & [Monitor_SN_Txt] & "'")

I have already done that. They are joined via serial and using the dlookup, but just keeps the last updated record device type info.

The Device_Type field is unbound. How do we resolve this. I would like via dslookup to pull the info from the Inventory database and keep all records correct. Sorry new to this.

I have some code. It is working great and grabbing the Device info from an inventory database and putting it into the current form device type. The issue is that it displays the sames device in every record from that point on. Any help would be greatly appreciated. Private Sub...

Yeah but in field 1 they enter a serial number field 2, 3, and 4, pull info based on that serial number from another database which works great, but until they click next to save that particular record and then back to come back to it fields 2, 3, and 4 are not updated. They want those fields to...

I am learning this who access thing. Kind of thrown into the fire. I would like to use and after update command, but would like field 2 field 3 and field4 to update once serial is updated.

I have a form that we enter in a serial number of a piece of equiptment. That in return looks into a linked database called inventory to get the model of the machine. For some reason those records do not update until I go to the next record and then come back to this record then those fields...

I have gotten no where. This thing is kicking my butt. I have worked with access before, but this one is kicking my butt where to begin. Any help would be great. Thanks.

I am trying to create what I would believe to be a simple database. I want workers to be able to cread a new lead(customer). Then myself and another engineer go in and put down how many hours that lead brought the company. Then at the end of the month see which employee brought the most lead...