Search results

I have a VB front end that uses an Access database for data and to make reports. The front end passes parameters to the Access report, sends the report to a snapshot file, and then opens a VB form that contains the snapshot. This works fine. The problem is that when he runs the front end, his...

Does anyone know if there's a way to see how many Megs of data are in an Access database? I know if you right click on the Access file in Explorer and go to Properties, you can get the size of the database. However, I'd like to find out the size of the data, not including the memory taken up...

I have an Access db that I'm using to hold data and make reports for a VB front end. I have a report that has several controls (eg. Type) that are bound to the database. If I want to limit the report's output to certain criteria (for example only give output for records with Type = what the...

I have a report in Access. It its Detail section, there is a control that lists tables. The report prints just fine, listing each table after another down the page. However, these tables take up a lot of space going down the page, looking something like this: [Lots of blank space]GA086[Lots...

I want to call an Access report from Visual Basic. In the VB app, the user decides what parameters to be set when the report is run (eg. 'Name' = 'Bob' or 'City' = 'Chicago'). After the user selects the desired options, the code generates the SQL statement. I've read the posts about how to...

I have a function that takes three recordsets as arguments. I would like to create a recordset from these recordsets where the PKs match. Something like: SQL = "SELECT * FROM rs1 WHERE rs1("PK") = rs2("PK") " SQL = SQL + "AND rs2("PK") = rs3("PK")" I've read this forum, and have not found a...

I've been given DDL scripts so I can create a copy of a database in Access. I would like to simultaneously create the tables and assign their default values, but I can't. If I do this: SQL = "CREATE TABLE tablename(" SQL = SQL + "ID CHAR(11) NOT NULL, " SQL = SQL + "CD...

I have a report that has a query as its datasource. The query has a numeric field (Indents) and some text fields. What I would like is for the text fields in my report to be indented, or have the Tab key pressed, depending on the number in the Indents field. The indenting would only happen...

I'm doing a review of database design, and I'm wondering if anyone out there could give a link to a site that has a good explanation of the rules of database normalization. I apologize if this is the wrong forum, but it looked like the best choice. Thank you for your help, Steve Geller

This is probably a very simple question. I have a parent table and a child table. The parent table has a form, and the child table has a subform within the parent's form. The parent's PK is an autonumber. The child table has a field for the Foreign Key as a number. What I would like is when...

I am doing maintenance on a database that has a subform that's inside a form. Before I made changes to the front and back end, the subform worked fine. A user could enter data in the first row, another row below it would be created, and there were no error messages. Now, however, if a user...

I have subforms that are fine when their record source is a table on my hard drive. However, if I change the record source to link tables on the server, the entire subform is blank. I don't mean the individual controls in the subform are blank, I mean the entire subform is one solid color with...

I have a subform that has fields linked from the database (total project hours), a text field for user entry (hours used), and a field that displays a calculation (hours remaining). This subform is in a form so the subform can show multiple values. The problem is that when a user types in a...

I need to copy data from one set of tables (source) to another (destination). In the destination tables, some of the tables have less fields than the source tables (eg. Table2 (has Field1 and Field2) will be copied to Table1 (has only Field 1)). All of the fields in the destination tables are...

I'm doing normalization on an application that was given to me. The original designer has combo boxes (ie. multiple values) in some of the fields in the tables, and I want to change those to single values. The original designer said his reasoning was so his forms could have drop downs directly...

I have a subform with two pertinent controls. One is a combo box that gets its values (an ID number) from the database. The other is a text box that uses DLookUp to compare the ID in the dropdown to the ID in a table, and then return the name associated with that ID. This DLookUp is in the...

In my VBA, I need to refer to the file path (actually the .ldb file that goes with it) the database is currently in. Is there a way to get the code to generate the path instead of typing, for example: strLDB = "D:\DATA\My Documents\dbname.ldb"? Thank you, Steve Geller

I have an Access database on a server, and am trying to accomplish something similar to EndersG post "Limiting # of Open Databases", where I want to limit the number of people who can open the database at any one time to a set number. I don't care if they're in a form, report, or the central...

I have a form with some controls that are bound to the database, a Save button, and a subform. If the user makes any changes to the controls on the form, I don't want them to be able to save those changes without clicking on the Save button. Since the controls are bound, I have a BeforeUpdate...

I have a form that displays search results. The user can click First, Next, Previous, and Last to go through the records. This works fine, and the correct data is shown in the correct order. I am having a problem with displaying the count of the current record in a "1 out of 6" format. Here...