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

Sorry, but how would i go about doing this?

Thank you very much Len...much appreciated!

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

Hi, i have had this problem as well. The way i have sorted this in the past (and this may be the wrong way) is to compact and repair the database, then go to the table with the affected field. This should now have a row of ###### in it instead of #deleted. You can now delete that record and...

Been a while now but still getting this everynow and then. The only way to get rid of the #deleted is to compact and repair and then go into the tables to delete the record. Anyone else experienced this, have any ideas?

Its ok, i've managed to do it by creating a recordset and moving through it adding the name field to the text boxes as i went.

I don't think the wizard would help, what i mean is that i have 10 records in the table and i would like my 10 text boxes to display the 10 name fields.

There are other controls on the form unfortunately.

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

Sorted Ok figured out the problem, the standard code that Access puts in for buttons seems to have changed in 2003 from 2000 lol

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

Possible solution? The way i'm thinking of doing this is to assign a booking number when the booking form is opened using the BOF statement so that if there are no records in the recordset assign xxx/00/01 to it. But if there are records then i need to return the last booking number with xxx at...

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

Ok just had a look these i have 5 ticked one of which is DAO 3.6 Just compared to a different database which does work, and has roughly the same code and the same references are ticked :(

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