Search results

I apologize if this may not be the best place for this question but I wasn't sure where to put it. I'm working in Access 2007. I have an ODBC connection to an Oracle database where I have linked to a few tables. On a daily basis I need to query the tables for a list of customers and a bit of...

I have a report that contains a subreport. In the subreport I need a field where the user creating the report can enter additional information to display on the report. The text entered does not have any bearing on what records get pulled from the database or anything else. The report is ran...

I have a report based on a table. The table field names recently changed (out of my control) and when I updated the report with the new field names I apparently have a reference to an old field name that I cannot find. When I open the report it opens a dialog and asks for a value for that field...

I want to dynamically color the text(Forecolor) of a text box in the detail section based on its value. Right now This is what I have Private Sub Report_Open(Cancel As Integer) If Counter > 10 Then DoCmd.SetProperty "OperationCount", acPropertyForeColor, "#ED1C24" Else...

I am attempting to create an Access 2007 front-end to an existing remote SQL Server 2008 database. I created a new Access Project (adp) and connected to an existing SQL database. I entered all information in the Data Link Properties dialog and clicked Test Connection. Access said it was...

Here's the code: Dim srcDB As ADODB.Connection Dim srcRS As ADODB.Recordset Dim txtStatus As String Public Sub OMS_Update() Set srcDB = New ADODB.Connection srcDB.Open "database", "username", "password" srcDB.CursorLocation = adUseServer After this it just goes into calling a bunch of...

I have written a batch file that calls shortcuts to 4 macros in 4 different Access databases. The goal is for this batch file to run every night and update the 4 databases. The problem that I am running into is that for one of the databases it will run the macro completely through and then throw...

I am working with three different databases, all of which work together in certain areas, normally through linked tables. One database gets updated via csv files and the other databases get backed up primarily via this database. I am trying to automate the update process. I run the primary...

I have a query that strips the first letter of a string that is a combination of letters and numbers. I have this field in the query: Expr2: Right([ILOCATIO]![Line_Pole_No],Len([ILOCATIO]![Line_Pole_No])-1) This portion works fine, now I need to put criteria on this field to only return the...

I would like to add code to close the form to the on click event of an unbound OLE object. The object is in the form header and just displays a piece of clipart as a logo. I know I can easily make a button to close the form and place it in the form header, I just thought it would be nice to use...

I have a form that displays the quantity of tools on each truck. there are a little over 500 tools and some 40 trucks. the table is set up with every tool listed for every truck (500x40 records). I filter the form by the tool I am looking for and I want to display the quantity of that tool for...

When a macro runs, does it wait for the previous step to finish before beginning the next? In one macro I have it runs a query that takes a little time to run due to the large number of records. I want to close the database when the macro is finished running (this is an automated task that runs...

What is wrong with this code Private Sub Report_Open(Cancel As Integer) On Error GoTo err_Report_Open If Form_Turtle_Meter_Form!Multiplier = "F3" Then Me!Text8.ControlSource = F3 ElseIf Form_Turtle_Meter_Form!Multiplier = "F4" Then Me!Text8.ControlSource = F4 End...

Is it possible to open a database from a form in a different database? Not necessary to do so; it would just be handy to do from the form I already have up and looking at rather than having to go open another instance of access and go to that database.

There is a command CompactDatabase in the DoCmd.RunCommand action. I tried to use it in a macro to compact my database every so often but it gave me an error saying that you can't compact a database from a macro or VB code. My question is, what is the point of making this command available if...

Can anybody tell me why this SQL statement won't run in in the RunSQL macro action. SELECT Open_Issues.* FROM Open_Issues WHERE ((Open_Issues.Account_No)=(Forms.Open_Issues_Viewer.Text64)); It tells me that the RunSQL action must have an SQL statement for an arguement when I try to run the...

I want to make a button that will find a particular record and change the value of the field. I was hoping that there was some way to do this through a macro rather than making a new query. With the SetValue action you can do this with a form etc. but it will not allow me to do this for a table...

I have a form control with the input mask on it for a phone number. I am using an append query to append the information entered in the form to a table. I need to pull two fields from a linked table from another database. What I need to do is be able to compare the entered phone number in the...

I have a report based on a query. When I run the report I get a pop up that says "The specified field [FIELDNAME] could refer to more than one table listed in the FROM clause of your SQL statement. Is there some way that I can specify which table I want it to come from? The field is already in...

Is there a problem with using an IIf statement in the criteria of a query. If ther isn't then is there a problem with using a Between...And statement inside the IIf statement. Or, does anybody see a problem with this IIf statement being in the criteria of a query...