Search results

Ok due to user error (and my own fault for not archiving an old database) we now have two databases which have had data entered into with the same table structure. The table structure we have at the moment is with the related field in []: Propertytbl[Propertycode] is related to...

Hi, i have a table that has contact information in. It has contact name, number etc and company. Quite alot have the same company. I was hoping to split the table into two, a company and contact table which are linked. I've been thinking about this and not too sure how to go about it. Anyone...

I have two tables, a Property table and a System table. They are linked so that there are many Systems linked to one Property. Each System has a risk score and these vary within each property. My Property table has a Property risk score field and in here i would like the maximum System risk...

Ok this is hard to explain but i have 2 tiers of information in my report. Property and then Systems related to those properties. Ok so far so good. Each property has a score. I have sorted and grouped on this first. Each property also has a system which also has a score. At the moment all my...

Is there anyway to name text boxes in an array format? i.e. Text(1,23) Or if not is there anyway to use VB to cycle through the text boxes i.e i = 1 Loop until i = 25 Text(i) = codehere i = i + 1 Exit Loop Matt

What i'm trying to do is fill several unbound text boxes on a form. I have an "Employeetbl" with "Employeename" and a "Projecttbl" with "Projectname". what i want to do is have about 10 text boxes from left to right on my form. Then fill these with all the employee names from my "Employeetbl"...

Hi all, I'm just starting on a new project to create a scheduling database for a small company (about 20 people). What i aim to do is to edit calander entries (Month view) and view calander entries hopefully using a control that looks as much like Outlook as possible again this would hopefully...

Ok i'm opening a form with the intention of grabbing the last reference number and adding one then moving to a new record. However the form opens on the first record. Here is my code. Private Sub Form_Open(Cancel As Integer) Dim lastbookref As String Dim expans As String Dim Newbookref As...

I have a booking table with Bookingno (Text) and various other fields What i was hoping to do was create a unique Bookingno using part of the clients name and however many records there are for that client in my bookings table. At the bottom of my booking form i have a button with this code...

Hi, in need of some help I'm at my wits end!! I'm getting "Invalid procedure call or argument" pop up whenever my database uses any of the code. Any form that uses code in the Form_Open section now won't open etc. This now effects all my forms, i'm 99% sure that i haven't changed anything and...

Does anyone know if theres a way to append two access reports (each based on different queries) one on to the end of the other to make one report. For instance would: DoCmd.OpenReport Report1name & Report2name, acPreview, , Filterifany If tweaked be the right way to go? Cheers, Matt

On my form i have a list which takes information from a table. I have set column headers to "on". What i want to do is populate my combo box with the column heads in my list box. Anyone have any ideas? Cheers, Matt

I'm looking to change the record source of a report and then print the report depending on what button the user clicks on. Is there some way to do this?

I have two forms, a main form frmProperty and a secondary form "Training Details" you access the training details via a button on the frmProperty form. This is the code for the button. Private Sub Trainingbtn_Click() On Error GoTo Err_Trainingbtn_Click Dim stDocName As String Dim...

Ok i'm very new at SQL and i have a bit of a problem. Ok for instance in my query i have: [Forms]![INPUT PAGE MGT]![PropertyCode] in my criteria box. This works fantastically however is there a way to change what is written in the criteria box using VB code in a form?

Ok sorry to be a pain :D I have a main form frmProperty from where you can go via a button to frmTraining and these two are linked by "Property Code". On frmTraining i have an unbound combobox which gets it data from the tblTraining table. I want this to only display data for the "Property...

Hi all very simple question i'm sure but had a look through the forums and couldn't find anything. On a form i have 2 buttons, one for new data and one for editing data. When either of these buttons are clicked a few text boxes pop up and immediately display data (The first record of the...

Some of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked...

Some of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked...