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

Well it's been a week or two since I am worked on that part of my database. I think what I was trying to do is either have it so someone would click a button and then have then choose the file to import (The name would be different each time but the cell headers and field name for the db would...

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

Never mind I figured it out.

trying to think how to make an if statement so something like this. I know it's not correct but just need a little help. If Agent_ID = dlookup("AGENT ID", "Agent List" then MsgBox "I am an agent" Else MsgBox "I could not find that Agent ID." & vbNewLine & "Please make sure you typed the...

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

Say I have another field that I wanted to sum up that has numbers only would I still do the same thing but without the isdate function?

My brain was not have been working yesterday. It now works.

I have one in the forum header but its not reading right as I can count 5 from the data I have and it says 0 right now. =Sum(IIf(IsDate([Receive_From_Date(HP)]),1,0))

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

but I would I set the criteria in the query with that info? I tried (date() -5) but that did not work like I wanted it to.

Thanks for the help. It was in another form that was not pointing to that query but it works now.

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 will try that when I get to work and see if that can work

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.

Thanks for the help think I had a duplicate serial which I should not as I scan the serial of the machine at work. So hmmm. Will have to look at that when I get to work.

It worked but did not. I took a few serials from my list but the first one I did show in the list but a couple others I check did. I will take your second suggestion and see if that works if not I will just upload my Warranty Table as I made a backup before I ran it.

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

Thanks that worked great