Search results for query: *

Hi there.,...I'm trying to create a series of tabs, but the thing is, everytime I try to draw something so that it is visible when just one of the tabs is clicked, I end up getting the drawing on all the tabs. Any advice? Thanks, Dino

Hi there...is it possible to put more then 255 rows of data in a table? Thanks, Dino

Hello, I wish to be able to edit an existing datasheet entry in a form, without creating duplicate entries. So I thought I would create a "Save" button where the old entry is copied, the old entry is then deleted, and the new entry plugged into its place. Should I use the...

Hi there...I have two tables. What I want to do in a form is be able to search by SearchID in a combobox and to pull records with a matching number in two different tables. Here is the code that someone else graciously helped me to write, but it doesn't work. I'd be happy to send the file to...

Would anyone be willing to work with me briefly on resolving this problem I am having? I am very new to Access, and I have a file here I need some help with. It's easier to explain if I can send the document and discuss it with someone. Any takers? Thanks, Dino

Hello, I have this code here for searching a table tied to a form, and returning the entry that matches the search number. The code is below. How can I search an entry in a table no linked to the form? I've tried changing "[Number]" to "[Initial Patient Report].[Number]&quot...

Would anyone be willing to work with me briefly on resolving this problem I am having? I am very new to Access, and I have a file here I need some help with. It's easier to explain if I can send the document and discuss it with someone. Any takers? Thanks, Dino

Hi there, I have a table tied to a form. In the form, I can pull up an entry with a combo box that fills all the fields. However, if I try to edit the fields and then re-save, it says duplicates not allowed. Well I set the table data to avoid duplicate entries, but I do want to be able to...

Hi there, I have a combobox in a form tied to a table called "A." I also have a Table "B." What I want is an IF statement for the combo box, so if a value is selected that exists in table "B" and not "A" only fields 1-5 on the form are filled in with...

Hi...might be a tricky one to explain. I have a field box that calculates an autonumber for a form. However, I would like to have it be a combo box, that you can select previous autonumbers from a table, but if you want to add a new autonumber, you just select "Autonumber" from the...

How would I structure an "On Lost Focus" command which directs the cursor to the 5th field in the tab index? Thanks, Dean

Hello, Any help would be appreciated. I have a table and a form called "Initial Report." In the form, I enter some info on customers, which is then copied into the table automatically. This includes an autonumber. Now, I also have a form called "Sales." I want to be...

Hello, In a form, I have a combo box which, when a number is selected, I'd like it to jump to the next field in the form which is "Initials." I have this afterupdate code: Private Sub Combo151_AfterUpdate() GoToControl.Initials End Sub But all I get is an error message saying I...

Hi everyone I have an option group called "Gender" in a form. Selecting male returns a "1" to the table I have. For femlae it is "2". What I'm trying to do is have the table return "Male" or "Female" to the table instead, not a number. I've...

Hello, I need help yet again. I have one form where I type in an ID number, name, date of birth, etc. Now I have another form where I have a pulldown menu that shows the ID numbers already entered in the first form. How can I set it so the name and date of birth fields in the second form are...

Hi there. I have a form with an autonumber field in it. Is there a way for that field to be blank on my form until the auto number is there. Right now, it starts off with the text "(AutoNumber)" in there. Thanks, PharmaFun

Hello, I'm very very new to Access and not too knowledgeable, so please be patient. I have an option group within a form designating male or female gender that returns a value of 1 and 2 respectively to a table. I'd like it to return "M" or "F" in the table instead. How...