Search results

I have an unbound text box called summary that pulls data from the below fields after the = sign from my form. The problem is I want it to pull from another table in my access database and the end of the code below like & Remedy_Templetes_List and the field name Summary. The table is called...

I have an access database that I am working on. What I want to be able to do it import an excel sheet into the database using some vba to make it easier for someone else to update a table of mine. Right now I have updated this table using the Import & Link under the External Data. Every so often...

I need to check the value in a textbox/Combo box to see if it's in a specific field in a table. I was thinking I could use the dlookup command on my after update event. Info is below. Table Name: Agent List Field in Table: AGENT ID textbox/Combobox on forum: Agent_ID

I have an access forum that I need to have a textbox count how many rows have dates in my "Ship_To_Date_HP_" field

I have a table in my current work database (table is linked to another access db) that I deleted a field that I no longer need. I am editing my database some. One of my forms I want records source to be a query and not the table so I created a query, now when I change my record source to the...

I currently have an access database for work. I want to add fuctionally for common troubleshoting techniques when diagnosing computers. I want to be able to add stuff to it but also be able to look up stuff like if it's a laptop what kinda common troubleshooting things should I try to figure out...

I only want to update a table with the form data after its complete and I use the DoCmd.RunCommand acCmdSaveRecord as I have an If statment that checks a field for something and if thats that I don't want that record in the table to update as I also want the form to be cleared if that makes sense.

I have a Unmatched query that displays what I need but I want to clean up my database and remove them but its not letting me. See sql below. DELETE Warranty FROM Warranty LEFT JOIN Serials_Repair ON Warranty.[Serial] = Serials_Repair.[Serials_Repair] WHERE (((Serials_Repair.Serials_Repair) Is...

I have a access db that has a Map address button on my forum. That when I hit it, it will map the address from the forum I have. Think I did something wrong. See below: Forum boxes names, Address_Line_1 City StateProvince ZIPPostal ex address. 19738 Germantown Rd Germantown, MD 20874 If I...

I have a forum that I need a weekly query. I have a daily one but I want to be able to run a report based on a query of what I inputed for the week. My week is Mon - Fri. I think I do now() + 5 right? I tried that but it did not show me all from today this is past week monday aka the bigging of...

Dunno if I am in the right section but I have a access database that I use to create warranty sheets that I print out and attach to the machine. Current to fill in the model and End Date(Expires) I do it manually. Is there a way i can get do like a screen grab and paste it into the fields on my...

I have a warranty repair database that I use to write up HP computers that have an issue so that we can send it to our Richmond config center. Current I can only write up one at a time. I have notice lately that when I write them up I will get a handfull with the same issue. On my forum I have...

I have a simple database that I put my execptions in for the day for scanning. Is there a way that my serial field on my forum can check to see if someone already scanned that serial for that day using the "On Lost Focus" event.

I have a simple database that is on a desktop that I have a shared folder and have not had issues till now. What would cause it so say, "This database has been opened read-only." Nothing has changed. Only thing my co-worker did was reboot the machine a few days ago.

I have a database that I use for keeping track of clients and printing invoices using a form/sub-form and report/sub-report. I want an image to be visible on my sub-report when I choose Received Payment in my sub-form. Right now I have my image set to visible = no.

I have a form that has a check warranty button that brings up the HP Warranty check web site so I can check the End date for the Wty: HP HW Maintenance Offsite Support. I have seen people create power scripts and our work computers using PCInfo light tell us to but how would I code it for access...

I have a form that a user like myself fills out. (I have the tab order set the way I want it) On my form I have a serial box where the user types the serial of the machine he/she is work on. Next to that is a Check Warranty button that copies what's in the serialbox and brings up the HP warranty...

I currently have a 2010 database that I use for clients and the work I do for them. In the sub-forum is the work I do for a specfic client. Currently I have a checkbox that I check if I want that specfic Work Done on the there invoice. My invoice is a report/SubReport. As you see in the picture...

I have a daabase that I currenty have that I keep track of the warranty repairs, aka this laptop has a broken LCD screen or this desktop has a bad hard drive. What happens is on a weekly bases my boss needs a count of what warranty repairs I need to richmond for repair that get counted like...

I have a DB with a form and subform. My form is for adding the clients and my sub form is the Work Invoices for the clients. My two table are linked. What I want to be able to do is selct a client and WorkID (Work Invoice) and print a report (Invoice) with the clients info that I selected and...