This is driving me crazy. This is extremely simple yet I cant seem to figure it out. I'm trying to get it so a couple of checkboxes are enabled only if there is data in a text field. I've trie...
I have a large collection of MP3 files (75,000). I would like to build an Access 2007 application to track and play the files. I started this once before using hyperlinks to the files and it...
Hi Guys!
I'm working on an Application that has a Parent Form link to a Child form. Parents form has a Customer ID and name, and Child form has Contact people to parents form. Now for every C...
Hello,
I'm not sure if this is possible or not but what I'm trying to do is get Access to delete a target file (word doc, image). I have a form that contains a link displayed in a text box ...
I am about to scream at all of the errors I am getting in Access!! I keep getting errors that pop up almost nonstop while I am trying to edit my code in Access 2003. I think that I created a...
I am using a macro in Access to import a comma delimited file. However, I encounter errors while importing because a field is automattically to an integer data type. There are records in the...
I have a query where I provide a sale date for the parameter called "Sales Date". I then export the result set that shows all sales for this day in MS Excel. I save off a MS Excel file for e...
I have a textbox that current reads the employees ID from an Access database. I have gotten this if statement to work find for that textbox control:
=IIf([empID]="xxxx","______",[empID])
...
Our company's product are constantly evolving and I need to be able to be able to create a family tree for a specific product showing either all its previous incarnations or all its previous a...
I have a form. On it is a subform control. Based on numerous things, I change the SourceObject:
Me.SubFrm_Display.SourceObject = "SubFrm_A"
In another part of code, I need to access th...
I've never used the Macro object in Access, but I've inherited a project, and I need to. I cannot get the runcode option to run a UDF, getPeachtree().
The macro name is importPeachtree; so...
I can't figure out how to access a file opened for output in several methods. So:
Open "c:/somefile.txt" for Output as #1
How can I access #1 from a method outside of the method where #1...
Hi experts,
There are 2 subforms. sfrProjectDetails and sfrProjectRevision. The subform sfrProjectDetails get their data from the table tblCapexData where as sfrProjectDetails get its data f...
I am getting more familiar with recordsets however I don't have that firm of a foundation, so this question may seem pretty basic.
I have a record set
rs.Open "SELECT tblPersonStatus.St...
Hi,
I have a form called (frmPatients) in that form I have a trash can to delete record.
I am not able to delete the record because there is a related child record.
error: Microsoft o...
I have created a form header in a tabular format using a combination of bound and unbound text boxes and labels. I'm having difficulty formatting the boarders. The border are thick in some sp...
Using VBA code, ADO, and Sql Server, I get "Timeout Expired" when trying to find a record in a table. All other machines are executing the same code, updating different document records. The...
MS-ACCESS-2003:
I want to add a step to my Macro where it simply takes a query that is in the current database and exports it to another database. That database would have a name that woul...
In Access VBA, I want to write code to auto save the word doc in a pre-defined name. I want to do something like this:
doc2.SaveAs "OrderNo" & " & Me!cboEnterOrderNo & " & ".doc"
For...
I have an MS Access application where I send an email out to a customer using Vba code. I use DoCmd.SendObject to email a customer the information.
Everytime I send out an email I get a ...
I have this sub
Private Sub Binttype_Click()
With Forms("fmiscoperations")
CurrentProject.Connection.Execute "INSERT INTO table(Type) VALUES('" & .txtIntType & "')"
MsgBox ("Record has...
I have some code (that I did not write) which is calculating deferred revenue. After calculating the deferred revenue, the data is output to a report. The call to the sub procedure that does...
It would be awesome if access had a record Macro feature like excel.
Anyways I have been asking a ton of questions today and I (and my office) appreciate your help.
Is it possible to cha...
I am developing an Access Database into which individual Excel files will be imported on a regular basis. The Excel files could potentially have records that have already been imported into t...
I have an error message (missing operator) and I can't find the problem.
What is wrong in that code?
UPDATE t1
SET
t1.MU_ID = t2.MU_ID
FROM
tbl_IEX_Formation t1
INNER JOIN
AGENTMA...
