Search results

Hi all I've searched the forum but couldn't find anything helpful. I have a Main Form, with a Sub Form on it. They are linked with the field RefNumber, which is an Autonumber field counting the amount of records. What I want to happen is: As soon as the RefNumber changes, I want a field on the...

Hi guys Couldn't find anything like this in the forums. I think the title explains it really. As soon as I add a new record on the Main Form, I want to reset a number field on the subform back to 0. I tried using a macro and the NewRecord method in VBA, but I couldn't get it to work. I thought...

Hi guys My main form is linked with my subform via RefNumber. I want to change the value of a field, Counter, in my subform, as soon as the RefNumber (found in both forms) changes. RefNumber is an Autonumber. RefNumber is basically the amount of records, so I played with the idea of using the...

Hi guys I've had trouble with this for quite a while now. Can someone please help me? I have 1 autonumber, Refnumber, which is sequential and it's my primary key. I then have a Combo box selection field, RefDistrict. This is a string field, with the selections being: DFE; DPZ; DAB; DGG; DAS...

Hi guys I searched for my answer but then realised I don't really know what I am looking for. I have a (what I think is a basic) problem, about autonumbers. I have a table, CallsToCustomer_tbl. In this table I have 2 fields, RefNumber (which links to the main table, and in the main table...

Hi guys/gals My primary key, RefNumber, is a sequentual Autonumber field. I want to creat my own Custommade autonumber field, but the catch is: My autonumber field should have any of the following (selectable by the user from a combo box from a Form) attached in front of the number...

I have a solution for my problem, I just want to see if there is an easier way. Here is my predicement: From...........To..............c 0...............100............5 100............500............10 500...........1000...........15 1000.........3000............25...

Hi guys, I know this has been discussed before, but I cannot seem to find any threads regarding this issue. So, I'm using the tab control on my form, but every time I open my form the view scrolls down and I cannot see the actual tabs. Is there any way to correct this? Thanks kruger101

Hi all I've created a database from scratch. No data attached anywhere yet - I'm planning to input the data manually through my Form. Well I have about 15 tables - CustomerInfo_tbl is the main table with the field RefNumber my primary key (it's an Autonumber which is sequentual). The rest of...

Hi all, I have searched this forum but it's almost impossible to get what I am looking for... I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or...

Hi all, I have searched this forum but it's almost impossible to get what I am looking for... I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or...

Hi all, I have searched this forum but it's almost impossible to get what I am looking for... I've designed a database that gets modified and upgraded daily. The problem I have is that the Form I use to enter data should be available in 3 languages. All I want to know is: Is there some or...

Hi there. This might sound stupid but I want to do quite advanced calculations (trigonometry) in VB. Is there someway I can do this? Thanks a lot for the help. I'm near to my deadline so I have to finish this quickly. I've searched this forum but haven't found any help. Regards kruger101

Hi guys I have a problem. In form view, if you use the mouse wheel to scroll down, you switch to the next record. Is there a way I can disable this? Even if I switch the RecordSelectors and NavigationButtons properties in the Form Selector to "No", it still goes to the next record as soon as...

Hi all I'd be very thankful if someone can please help me with this problem. I have 1 Table. This Table is imported and contains data from Excel. It also contains fields I added manually. There is about 20 imported fields (full of data) and about 100 manually added fields. Then I made a...

Hi I'm encountering some problems with some simple Code I've copied from someone, I'm just using my variables (field names) in stead of the author's. I'm really new to this too so please be patient. I welcome any responses. I'm trying to auto populate the form as soon as you select the first...

Hi I'm encountering some problems with some simple Code I've copied from someone, I'm just using my variables (field names) in stead of the author's. I'm really new to this too so please be patient. I welcome any responses. I'm trying to auto populate the form as soon as you select the first...

Hello I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish. Well I created a Form and what I want to do is this: If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.). Can you...

Hello I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish. Well I created a Form and what I want to do is this: If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.). Can you...

Hello Im having trouble with access and im kinda new to it so ne nice ;) Ive searched the forum and i havent found anything helpfull... I want to link a single cell in excel, another file, to my access query... how can i do this?? Thank you in advance. :)