Search results

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...

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...

Is there a way to only allow one user at a time into a database? I tried setting the Default Open Mode (found under Tools:Options:Advanced tab) to exclusive, but that still allows more than one person to be in a database and alter data. Is it also possible to alert the second user of who is...

Is it possible to change the size of the picture I put on my command button so that as the command button gets bigger, the picture does as well? I've searched the forum and haven't found an answer yet. Any help would be great! Thanks!! :rolleyes:

Hi, In my database, I have a function that allows users to pull reports and export them to Excel. All of the information shows up perfectly on the database report, but as soon as I export it to Excel some of the information gets lost, specifically the zeros that lead an account number. Not...

When I try to run a report from my form and it fails, I receive this error when I try to close out of the form: "This action will reset the current code in break mode. Do you want to stop the running code? * To halt the execution of the program so the Module window can be closed, select Yes...

Hello! On my form I have the option to choose several different account numbers and run one report to display information for all of them. Since these reports can get quite long, I have an unbound text box, next to the title of the report, that I would like populated with the referenced...

I have a multiselect form that is attached to temp tables and queries. I copied the following code from another database I work with, but am unable to get it to work with the one I designed. I think there might be a problem with my Dim statements because when I comment them out, my form will...

I have a group of tables that filter information to each other in an Excel spreadsheet and I’m trying to set up an Access database that will allow this feed to continue. One spreadsheet has ‘permanent’ information in a three-dimensional format (shown below). Another table reads values out of...

Is it possible to combine two lines in a text file to one row/record in an Access database? The import wizard allows me to set my columns, but I cannot create proper columns because my data imports into two rows in a table. Having information on two rows that do not line up make it impossible...