Search results for query: *

Hi, I want to check the current database if a certain table name exists. If so, delete that table, otherwise, run some other code. The problem I'm having is referencing the table name. Below is my code currently: Chain = InputBox("Enter chain number. Do not zero fill") If...

I'm trying to filter a form whose source is a table. I'm filtering on a date field, but it's not working. I'm not using code to do the filtering, just the Form properities window. I'm trying to only return those records where the date is 12/7/05. In the option for Filter, I'm typing...

Hi all, Is it possible to do a grouping in Forms like Reports? For example, I have daily sales data that I'd like to sum by the week, while showing all the daily detail as well and then have a grand total at the bottom. Getting the grand total is not a problem (Sum statements in footer), but I...

Hi, can anyone help me with some quick and dirty code to import a text file into an Access db, which allows me to name each field as it's imported? I've looked at the TransferText method of the DoCmd, but it doesn't look like you can name the fields, other than the first row of the file...

Hi, I have a query with a date field and want to add criteria to only return records between certain dates. In the criteria section of the query for the date field I have Between [Enter a beginning date] And [Enter a ending date], which brings up two input boxes asking the user for each date...

Hi, I have the below code, but keep getting an error (Invalid argument, Expected 1) on my execute line. DtTxtBx = Forms![Form1]![Text13].[Value] query = "SELECT * FROM qryDates Where [Start Date]>= '" & DtTxtBx & "' order by [ChainName]" My Start Date field is a text format (yyyymmdd) and...

Hi, is there any form property that I can set so that a pop-up window will come up warning the user that the current record has changed (assuming the user made a change). If no form property, any suggestions of how to perform this? Thanks much in advance for any help.

I have an Access 2000 db and writing code to export records in a table to Excel. I've got that working, but I want to include some validation "rules". If it's the first record in the recordset I want the code to export to column E in Excel. However, I don't know how to code VB to do this...

I accidentally posted this under the Forms forum and was told to put it here. Anyway, I'm using Access 2000 and wondering if it's possible to have a columnar report that's grouped on a particular field. This way other common fields can be compared across each other, similar to a crosstab...

I'm using Access 2000 and wondering if it's possible to have a columnar report that's grouped on a particular field. This way other common fields can be compared across each other, similar to a crosstab query. It's hard to explain, but easier to illustrate: Company ABC...

Hi, I have a form in my Access 2000 db and I was wondering if there is a way to only tab (Tab key) through the fields on the current record and not tab to the next record. As it stands now, if my form has 5 fields after I tab through all 5 fields the next tab is onto the next record. I'd...

I have an Access 2003 database setup for about 6 users on a network. The tables are housed on the network server and the users database's (queries, form, etc.) are housed on their local machines. All users link to the tables on the network. Everything is working fine except one user is...

Hi, I have a form in my Access 2000 db and I want to select any number of records, using a checkbox and then add those to a recordset. However, the checkbox is only on the form and is not located in a table. Any ideas because I'm stumped. Thanks much in advance

I'm trying to change the font color of a field based on the value of another field on my report. If ETA is greater than required delivery date, the value in the ETA field should have a font color of red and bold. However, ETA is red regardless if it's greater or not. Below is my code that I...

I have a combo box on a form that finds a record on a subform. The source of the combo box is a text field in a query. The code for the event was created by Access' combo box wizard. It works fine unless there's a ' in the value of the field, for example, 2' waves. I'll get a syntax error...

Hi, I'm trying to do a simple OnCurrent event using Access 2000, but to no avail. The code is suppossed to pop up a messagebox if the current record is new. I have the below code saved as a module: Sub NewRecordMark(frm As Form) Dim intnewrec As Integer intnewrec = frm.NewRecord...

This is a reach, but is it possible to filter a file before importing or linking into a Access 2000 database. I have a huge text file that I need to link or import into Access, but since the file is so big it's cumbersome to work with. I only need a few thousand of the millions of lines in the...

Hi, I'm a long time Microsoft Access user/developer, but new to Access 2003 and setting up databases over a network. I've created a database in a network folder. When I go to computers connected to this network, I'm able to open the database on each computer, but not have it open on multiple...

Hi, I'd like to add some very simple security to my Access 2000 database and would like to know the best approach. I want to just add a database password so that everytime the database is opened, the user is prompted for a password. This database is also the source for a few Excel files...

Hi, I have a query with a nested IIf statement that is not working correctly. The problem is happening in my final else statement. I'm getting values returned, but not the correct values. Below is my statement: Sum(IIf([Chain]="1_data",([Current EVDY...