Hi Pat
Not actually using the time to calculate totals just using the time values to see if the item is booked elsewhere between 09:00 and 12:00 for example and if it is that means that it is unavailable to book.
Cheers Phill
phill86
Last Activity: Feb 28 '12, 01:14 PM
Joined: Mar 11 '08
Location:
-
Hi Thanks for the suggestions unfortunately the table locking is not an option as I will have several users needing access to the table at the same time.
An extra step seems like a good idea but i opted for a random time delay when the book item button is pressed this will make it even more unlikely that two users will book the kit at the same time.
Thanks for your help
...Code:Dim MyValue Dim PauseTime,
Leave a comment:
-
Preventing two users adding a new duplicate record
Hi
I have an shared application with a front and back end which is designed to book equipment to a room at a date and time specified by the user so the user will be able to create a record as follows
User 1
Item 1 room1 1/1/2011 09:00 - 1/1/2011 12:00
I have some code to check to see if item 1 is booked anywhere else between the time and dates specified above.
So if user... -
Unrecognised database format access 2010 to 2007
Hi,
I have created a database in 2010 and have opened it in 2007 and it has previously work.
When i now try and open the 2010 database in 2007 I get unrecognised format error I have created a new blank database and imported all the objects into the new database which failed to work I then imported the seperate objects individually and I have tracked it down to two forms and after some digging on different forums I think... -
Disable right click shortcut menu in tabbed documents
Hi,
I have enabled tabbed documents and display doccument tabs in options current database and I would like to disable or change the drop down menu that you get when you right click on a tabbed form is this posible?
Many thanks
Phill -
Hi
Thanks for the reply the solution from ADezii worked many thanks
PhillLeave a comment:
-
Array varying length Run-time error 9
Hi
I have a field that stores a recurrence pattern that is imported from outlook
example recurrence pattern
(3,20101208,10: 00:00,1,0,4,120 ,2,20110331,12: 00:00,)
The pattern is not always the same length so it could have up to 13 elements.
I need to split this field up and assign the different elements to variables I have done this using an array
I am getting Run-time... -
Access 2010 data macros convert to SQL Triggers
Hi,
I have an access 2010 database that I want to convert to an SQL Server database and I need to know if the data macros in access will still work in the SQL database or will i have to create triggers in the SQL Sever database
Many Thanks
Phill -
Hi Neopa
Thanks for the reply
Yes it makes it much clearer I have sorted the problem now
thanks for your helpLeave a comment:
-
Hi Neopa
Sorry what do you mean?
I know its probably really simple but could really use some help on this
Many thanks PhillLeave a comment:
-
Count records in a dao.querydef
Hi
I want to be able to count records in a dao.querydef recordset but I keep getting the error message method or data member not found
I have also tried to find out if the recordset is at the EOF either of these metods would work for what I need
...Code:Dim RstQueryCheckCal As DAO.QueryDef Set dbsEquipBookLinked = DBEngine.OpenDatabase("\\bert\sessiondata$\equipdata\EquipBooking2007v15Data") -
Hi,
I have found the answer
http://bytes.com/topic/access/answer...ow-use-subform
Thanks for looking...Leave a comment:
-
Split form and subdatasheet
Hi,
I am working in access 2007 and I have a split form that has the datasheet on the bottom in that datasheet I would like to show a subdatasheet which works fine in the undelying query but on my form it will not display the subdatasheet I have also tried using a subform that is set to datasheet view and this does not work either.
Any ideas?
Cheers Phill -
Query Criteria
Hi,
I am trying to write a query that does not display a record according to criteria
The database is a room and equipment booking database the form displays the room details and the equipment that is booked to that room.
This is displayed in a continuous form using text boxes that represent an hours time slot so if the equipment is booked form 09:00 - 12:00 the three text boxes representing the time 09:00... -
Unbound check and text box's on a continuous forms
Hi,
I have a continuous form with check boxes and text boxes that I need to be unbound.
I want to apply formatting to the text boxes and check boxes on the individual records in the continuous form i understand that this is not possible unless the controls are bound to a field in a table.
I have found an example database written by Albert Kallal at the following link that allows you to use a unbound check... -
Entry log database from Access to VB
Hi,
I am an MS Access user that is making the leap over to VB 2008
So I am very new to VB 2008
So please excuse me if this is a dumb question
I have an entry log database that I am developing it basically logs people in/out as they enter/leave the building.
Basically how it works.. as a member of staff enters the building they swipe their entry card across a card reader... -
Hi Stewart,
I will have a look into the visual studio stuff
Thanks for your time its very much appreciated
Redards PhillLeave a comment:
-
Hi Stewart,
Thats what I thought
Any idea what programming language would be able to handle this type of application.
Thanks for your time
Regards PhillLeave a comment:
-
Onopen Onload form events
Hi
I am trying to run a function when a form has been opened
The function changes the colour of some text boxes on the form
I have tried running the code on the onload, onopen, oncurrent event
these all run before the form is "actually" open and so my function is unable to change the colours of my text boxes
The function works fine when I run it via a button on... -
Reception entry log database
Hi,
I have an entry log database that I am developing it basically logs people in/out as they enter/leave the building.
Basically how it works.. as a member of staff enters the building they swipe their entry card across a card reader the database logs whether they are entering or leaving the building
I want to be able to run the database in the "background " while the user/receptionist is working...
No activity results to display
Leave a comment: