Search results

Hi Hullstorage make sure you turned 'macro security off' :)

Hi Nigel its not exactly sunny today! Well its a bit of an odd problem tbh I needed a temporary table to base a booking plan on -looks pretty cool now:) I have decided to sort this out using an Update query which "Nulls" all the records not required and then I follow this with an Update query...

that way should work fine I haven't had a problem using my 03 in 07. However the other way round is a pain - you will need to 'save as' 03 database.

Hi rhett7660 This looks what I was about to suggest, although why is there a separate table for a site - would there be many sites to one location?

If this is happening with new files have you tried using a different computer with the same file. This would distinguish whether its a problem with the software or with the files. The error message doesn't really explain much:(

Hi folks, just thought I'd reask the question as it may not have been clear: i have a table 1 a no 2 a 3 a no 4 a no ... The numbers will always be the same i.e upto 10 I need the blank spaces so I can display...

Hiya you might need to add a start and finish time as restaurants normally like to have multiple people using the same table. Secondly the best way to work out availability is to have a query of which tables are booked and then query this against all the tables to work out available ones, then...

Hiya just saw this on google answers explaining it. btw there is a COUNT DISTINCT but you cannot use this with Access:*( Ok this question should be relatively easily for someone who knows their SQL. It has to do with COUNT and DISTINCT I'm using Microsoft SQL Server. All right I have a table...

does using the expression Count([fieldname]) not help otherwise use sql's 'select distinct' in a query then go on to count using that query

Hey Sandro You will want to keep the 11 columns tbh otherwise you wont be able to add records easily. you may want to add an extra table and put the questions in that table.

yeah definitly agree with above, If they are making partial payments etc you need to have one table to calculate what s the total they owe and the another to work out their payments made.

Hiya Ryan, From your description I would proceed with this setup tblCustomers and tblTransactions in the customers table have fields with details about customers have one field CustomerID and select this as the primary key using auto numbering Then put transactions in the other table...

Hi Nish, i'm not positive however this does sound like a security issue. I know of other applications/policies that block zip files etc. try using it on a different machine?

yes there will always be the same amount of rooms. I found the seating database I am trying to copy however I cannot make any sense of the actualy code regarding setting up the seats in VB.

yeah, on the db i attached it has the form and a table the table has the caption names and a checkbox for 'status' if status is checked then I would like the backcolor to change to red etc. :)

90% of bookings wil lbe for a whole term so I have created a temporary table based on dates linked to a scheduling table. I have seem this before on a cinema booking database I think. I am just unsure how to get vb to pick up the lables via the captions:(

Heya have you tried using the command button wizard from the toolbar create a button then select 'find record' in the wizard. as for the other info - have you got fields in the form where the user puts his name or a timestamp? cheers James

raskew is spot on i had to add the criteria to bobs original one. Edited for a cheers to raskew:)

Hiya i've just been generating a few reports could you upload your db so i can see what you need. James

Cheers Bob\RuralGuy Exactly what I was looking for James