Search results

Hello Pat, First, thank you for responding. This will be a long response because I want to tell you exactly what I am trying to do. All of my forms are based soley from tables. That was the only way that I could figure out to make the security work. I would still be called a beginner at...

Hello all! I have five different forms. On one of the forms I would like to be able to pull data from 2 different tables. Another words, when a user updates these particular 2 fields in their form, I want it to update their table and I also want that field to be displayed on another form. I...

Thank you for responding Bob. I think that I have made it work. I actually had to trick Access. The primary key was set to autonumber. I know probably not a good idea. The database was semi built when I took over. Anyway, I deleted the relationships between tables. Then, I deleted the...

Hello all! I am having trouble using an append query. It looks pretty simple in the book and on Access help, however, I keep getting errors. I am fairly new to Access. I do no know Visual Basic. I was adding records to a table called "NNE table". I entered record 49 and then hit tab and...

Hey! Just wanted to say thanks. I have it working now. Somehow I was not getting the highlighted area like you said. I just kept playing with it and finally got the highlighted area. When you said that it had to be highlighted that helped. Karen

I am not sure that I understand. From design view of main form, I added tab control from the toolbox. Then, I stretched the tab to make the size of a regular form. I then clicked build wizard and added the form that I want to be reached by tabbing. It went over top of my main form. I...

Hello All! I have several different forms that I want to be combined by a tab control. In another words, I want the user to be able to just tab from form to form instead of having to open each form individually. I have read help on tab controls and all of the posts for tabs here. Every time I...

Are you saying that this: C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "X:\Databases\YourWorkgroup.mdw" "X:\Data\Bases\Test.mdb" /user Test User should be the file location of the workgroup file instead of taking the default location that they give you? Would that make a...

First of all thank you for applying. I am not an expert by any means and I am not sure that I understand what you mean by LAN ID and how to set up an access table to recogonize that LAN ID. I am not the administrator of the LAN, but only of the DB's. Karen

Hello All! I have a question that I cannot seem to find in help for Access or in a book that I purchased. I have multiple users on a network sharing multiple databases. Probably a total of 6 different DBs on the same network. They are not related and cannot be combined. I set up users and...

Yes! The record number is the primary key that I called unique identifier. That is the field that I have the parameter set up on. It is unique on every record beginning with "1" and going thru "47" I mean it is actually a field in the form and in the table. Karen

Well, I tried that and it did not work either. It just does not make sense to me that Access can understand when I type in "1" that I want the first record, however, it can not understand what I want when I type in "2" or anythng else for that matter. I really appreciate you taking the time to...

I thought that you had to have a primary key in Access. And also the primary key is the field that I have the parameter set on. Another words, in the query critiera field under the primary key (which in my database is called unique identifier) is where I have the : [enter record number]. Does...

I have 47 records in the database. And the field that I am using is the autonumber field that Access allowed me to assign as a primary key. Karen

I am still trying to do the same query. I am using a parameter query that asks for the record number. If the user types in "1" for the record number then all info is displayed. However, if the user types in any other record number, it only displays headers. I have the following in the...

I do have a unique identifier record counter already set up as the primary key. I also have a text box set up in the form. I do not have a "where" in my macro, or I don't know where to look for it.

Well, this is for our engineering group. They put a date in the date field that they actually begin the order. I tried to use that date, but could not because they may enter 4 records that morning and then later in the day, they may need to enter more records and I do not want those first 4...

Thank you for responding. I am not sure what you mean. The control button that they use is called "notify agilent". I mean that is the button that they see on the form. When they push that button, it starts a macro that runs the query and sends the results in an email to agilent. Are you...

Hello! I am running a macro that pulls info from a query. This macro is excuted by a user pressing a button on a form. I want to only return the current record that the user is on when he/she presses the button. I tried using date fields, but that will not work because they may enter more...

I am trying to make some forms in access read only. I know how to make tables read only under permissions, however, I cannot make the forms read only. I have five groups and five forms. I want each group to have full access to their particular form, but read only access to the other four...