Search results for query: *

Haha....that was so simple, and yet I couldn't figure it out. Thanks!

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

Sorry..,..what I meant was can I have a table with more then 255 columns? Thanks, D

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

Yes it is...I don't understand what you did. D

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 Ginger...no apologies needed...your help is invaluable. Yes the Data entry property for the form is set to Yes. Here is the code associated with AfterChange on teh combobox: Private Sub Number2_Change() Initials = DLookup("[Initials]", "Initial Report&quot...

Combo Box: Row Source Type: Table/Query Row Source: SELECT [Initial Report].[Number] FROM [Initial Report]; Number is the key field that cannot be duplicated. If I try to edit it, I just get an error that duplicates are not...

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

Thanks Richard, but that only sets the focus on a field by name. I have 10 forms, each where the 7th field is a different name. I was to set focus to the 7th field, irrespective of its name. Dean

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

Thanks again Rollie E. Yeah, I made the necessary changes, but whether the field "Gender" is set to text or integer, it still says "1" in the field for male. Any further suggestions. Sorry, I'm a knob at this stuff. Dean

Hi John....thanks again. No worries about the earlier error...it happens to the best of us! So I added this event to my gender options box: Private Sub Gender_AfterUpdate(Cancel As Integer) Select Case Me.Gender Case 1 txtGender = "M" Case 2 txtGender =...