Recent content by hobbes

I appreciate the help, but those options do not work for what I am trying to do. The information is being passed from Access to Excel. Any other ideas? Thank you! Hobbes

Is that for importing an Excel file to Access or exporting an Access report to an Excel file?

Hi, When I export a report to Excel it changes the data type of the column. For example, if I have a field in Access set to Text, but its data contains several fields with just numbers and other fields with a combination of numbers and text, Excel changes the format to Number. This problem...

Hi, I have been working with this code for several days and can't figure out where I'm going wrong. I am new to SQL and VB, but not to Access. Does anyone see where I'm going wrong in my code? This is behind a form with six combo boxes and 48 check boxes. Ideally, I would like the user to...

How do I limit the number of entries made by a user on a form? I'm designing a database that will show available classes and let people sign up for them. However, there are a limited number of seats for each class. How do I keep people from signing up for a class if all of the seats are...

Hi, We are going through a computer/software upgrade in our office and I am in charge of making sure all of the databases function properly. Due to processing requirements, Access 97 and Access 2003 will be installed on the computers affected by these databases. How do I program a specific...

I have a query which pulls all of the records I want. I have that query attached to a report that puts a page break after each account. One account can have many transactions which are grouped together. So I end up with a report that has various numbers of pages for each account (based on the...

Hi, I have a query that narrows my records between specific date ranges. I also need this query (or another query if I need to write one) to eliminate the records that are opposite each other from the results of the first query. For example: ID Name Act Number 1 ABC buy...

My company is about to undertake a huge upgrading project, where they will install Win XP and Office 2003 on every computer. Currently, some employees use Access 2000 and others use Access 97. Consequently, we have some employees that still run Access 97 databases. :( Can anyone give me...

Hi, I have multiple queries that end up producing a table with records that I want in a single row, but are currently in two rows. Here is an example of the table results: Account Number Name US Foreign 1234567 ABC Co. 125 1234567...

Thank you for the link! I'm not sure if I was missing something or just didn't understand, but I don't think I found the solution to my problem there. I don't want to import a file from Excel (the database is set to do that already). I just need Access to open the file (which should open...

My apologies ghudson....you came up with the exact same thing first. I, however, didn't understand it until my co-worker sent me a screenprint of where I needed to put the information. My bad for not realizing it was the same thing you had suggested earlier. :o I'm a bit confused....Why...

I found an even easier way (thanks to a crafty (like ice is cold) co-worker)! In the properties of your database shortcut, on the Shortcut tab, set your Target to read the location of Access on your hard drive or server and the location of your database. For example: "C:\Program...

Thank you both for your suggestions! From another post I was able to search with different words and found this discussion...http://www.access-programmers.co.uk/forums/showthread.php?t=67757&highlight=launch+file+access . I haven't tried it yet, and it seems quite complicated for a novice user...

Is it possible to create a macro or VB code to open an Excel file? Ideally, a user will open the database and press a button which will open the Excel file (which has a macro attached to reformat it), and then import it into the database and run a query (all of which are connected to another...