Search results for query: *

I've just started a new position and it's been a career change for me (went from accounting to database analyst). I'm moderately experienced with databases, but need some advice from everyone. We have a database of potential people we would like to send mailings out to. About everyday, a...

I'm using Access 2002 and I have an update query that takes a value from the table and subtracts out the value of another table: Update To: [Fix D4_ytd]![Consideration]-[Final]![Total] Now I have several other columns in the update query updating different columns by the same amount [Total]...

I have one Access(1) database that I would like to run a specific function in another Access(2) database. How can this be done? Basically, the function in the other(2) database runs some code and then executes a make-table query that makes a table in my first(1) database. Thanks in advance...

I am running a make-table query and I set up 2 fields where the values are zero. Later I run 2 update queries for these zero valued fields and I get a conversion error. What happens is when the make-table query runs, it sets these two field values to Long Integer. When I run my update query...

I am new to using ADO for data access and I'm having some problems. I'm using VBA in Access 2002 to try and access some data that I have stored in a table. I'm trying to build a connection to the database that I have currently open and I'm not having any luck. Here is my code. Dim conn...

I want to be able to subtract values from a subreport in my main report. How can this be done in my main report? Main Report Value -Subreport Value =Total Thanks in advance! Chris

Somehow, the main window for the datbase that has different pages for the Access objects, is too far to the top of the screen and is hiding the minimize/maximize/close buttons. I tried moving the toolbars out of the way, but it just moves up into that area. How do I fix this? Thanks in...

I have a form that allows the user to select certain reports. When the user is done viewing the report, I would like that form to open up again. Problem is, when I use the OnClose event in the report to open up the form, the report stays open. I suppose this is fine, but when I try to run...

I have a form with an option group and six option buttons in that group. The buttons are there to select a specific report. However, when the user selects a specific option button, I want a combo/list box filled with choices of company numbers (different reports will have different choices for...

I have a report that will have 3 subreports in it. The subreport is basic and includes one value, "Book Value". Now I display this value on my main report, but I want to add another textbox and subtract "Book Value" from another textbox on my report. I've tried several different ways, but...

I have another problem. I am running quite a few imports into my database and the import files are quite large. (75,000+ records). Each time I import one of these files, the database increases in size by the size of the table I bring in and does not free up the memory from the deleted data...

I'm having a small problem with a database. This database can be used by more than one person and only one of my coworkers is experiencing the problem. The problem is, when I'm in the database exclusively, she can't open the database at all (not even for shared use). However, everyone else...

Is there a way to capture the number of records returned for a specific query by placing it in a variable, table, etc.? Here is what I'm trying to do. I have a process that imports files one at a time into a specific table <Import Table>. With this table, I need to take out specific rows of...

Does anyone know the code to be able to export a table from Access into Excel in the formatted style when you export using the Access interface? I'm currently using the TransferSpreadsheet function, but that obviously doesn't work. I'm not able to use a macro to automate the export because my...

I'm getting an error that is really confusing me. I'm simply copying data from one excel worksheet and pasting it to another and I receive this error saying &quot;File not found&quot; then it says Excel cannot paste the data, but the data gets pasted anyway. What is the reason for this error...

I have a database that multiple users will use, but I want them not to be able to open (even shared access) that database when someone else is in it. They should only be able to open it when no one is in it. I have checked the exclusive box in the Options menu and that doesn't seem to do the...

This one seems so simple, but I just cannot figure it out. I have two tables, the first is a table listing all assets for a specific company, the second is a table of adjustment figures for those assets. So.... Table 1 Table 2 Company Company Asset Code...

I'm fairly new at Access and need a little bit of help. I'm using Access 97 to do an update query, SQL is below: UPDATE (FileNames INNER JOIN Final ON FileNames.Company = Final.company) INNER JOIN OutputTable_by_field ON Final.Cusip = OutputTable_by_field.Field2 SET...