Search results

I have two tables that are connected in a query. They both have a primary key as "ProjectID" and have a referential integrity with each other (Update). The first table (tblmaster) has all of the ProjectIDs (1000) where as the second table (tbltwo) only has about 5 records. I combined them in...

I have a form in Db1(mainDB) that when a record is added in a specific form (tblsampledatainfo) it needs to be added to a table in DB2(XRFdb) in table (chemistry). My problem is this, I need to get the ID for the newly updated record in the Chemistry table in DB2 which is an Autonumber. The...

This question is in relation to the last question I had. Can I pull data from Excel for an Update Query in Access?

In my database I need to export a query to excel so my coworker can update it. Now I need to create a button that will create an Update Query to update any changed information back into the Access query. How can I go about doing this. I have the following from other sources but somethings not...

I have a table "tblengopp" that has a field "Oppid" which is the primary key for that table. I have another table tblprojectinfo that also has a field "Oppid" that uses the Oppid's from "tblengopp" I need to create a query that shows all of the "Oppid"s in tblengopp that don't show up in...

Hello, I'm trying to add a new record to a different database than I'm in when a button is pushed. The following code is this: Dim db As database Dim rs As Recordset Set db = OpenDatabase("P:\BU Regeneration\XRF Laboratory\chemistry.mdb") Set rs = db.OpenRecordset("chemistry"...

I have a SendObject function on a report that will convert the report to a PDF and attach it to an email. However when a co-worker obtained a new computer with Windows 7 on it, (everyone else is using XP), the SendObject function doesn't recognize 'AdobePDF' as a format type anymore. I'm not...

I'm using the BuildCriteria function to develop an sql to filter a query on a subform: for each ctrl1 in Screen.ActiveForm .... sWhereClause1 = sWhereClause1 & " or " & BuildCriteria("Project_Scope", dbText, ctrl1.Name) .... This will produce "Projectscope = 'REG' or Projectscope=...

I have a button that has the picture "Sort Ascending" which was chosen from the given list of pictures in Picture Builder. When the button is clicked, I want to change the picture to "Sort Descending", but I'm not sure how to call on this in VBA... Any ideas?? Thanks

Is it possible to attach a calendar to a unbound text box, like there is for a bound text box, where when you click on the textbox a calendar will pop up?? Seems like there should be... I also created a new pop up form with just the ActiveX calendar object on it but can't get the "On Update"...

I have posted this at the end of my last thread but I wanted to ask it formally to better a response. I want to retrieve the full name of the user when they enter my database to greet them and to use else where. Assuming Microsoft Outlook is open, is there anyway to retrieve their name?? I...

I have code that would scan a recordset and email a user the records that met a certain condition. It worked fine until I added a lot more records to see how long it would take to scan. However after I did that, whether it had any effect on it or not, I now get an error message that states ...

Hello, I have a query shown in datasheet view as a subform. The table consists of a sample number field and chemical element fields. On my form I have a combobox that filters the query by a certain chemical and a range. Is it possible to move the column that the user is filtering for to the...

I have a co-worker than has an excel sheet that needs to be inputted in my database so I created a linked table to his excel sheet. My problem is, he keeps the excel file open 24/7 out of necessity, and when he has it open, Access won't allow me to open up a form with a query based off the...

Is there anyway to trigger a cell date or date field that when the date has passed that it will send an email letting the user know that a certain field's due date is late, whether or not the database is open? I was looking through the events and couldn't think of a way to do it, if it is...

My co-worker has an excel file that needs to be linked to my database. In one column he has "conditional formatting" to make value 2 to a check mark, 1 to a red "X" and 0 as (!). So when he puts in 2, it'll show a check mark etc. The problem is that I need to show this information in a...

Hello, I'm tryin to add the value "2007" to a field (YearUpdated) in a table (tblgdmreport) for all records. (I created a button to carry out the event) I have the following but I know I'm missing something/not doing it correctly. Private Sub Command9_Click() Dim dbmydb As Database Set...

I have a database saved on a company-used drive (P:) and after I split it I had each user make a copy of the front-end and put it on their desktop. Now if I make edits to the front-end thats on the P: drive , will other users see my changes when they open theirs on their desktop or will they...

I have a subform of a query on a form in my database. Users are allowed to edit the column widths and filter each column if so desired. My problem is that when the user exits the form, I don't want a pop up asking whether you would like to save changes to the layout of the query. I can't figure...

I have a query subform on a form I have, with combo boxes that filter it. I have the query locked so that no changes can be made to query, however, the user is still able to delete records from the query for some odd reason. I have to keep it "enabled" because the user needs to scroll right and...