Search results

thank you thank you thank you- you're also one of the few people who's nice when telling me I've done everything wrong! Right now it's the middle of the night though I'm still at work unfortunately this computer doesn't have access but I'm thinking if I post my db up first thing tomorrow, that...

thanks, yes I think it's a much talked about topic. Right I've read all those posts which has answered my first question- I manually need to create combo boxes which is fine though annoynig (when I first created my db I used these then discovered lookup and deleted them all. grr.) but I'm still...

Hi I got told off for my lookups in my main table. So I removed them all but now I don't know how to rebuild the input form- do I just add a combo box and make the source the relevent data table? and secondly I had another form which had the main table as a sub-sheet so you could see but not...

thanks. I was being a bit slow but I've now done it. muchos gracias!

Thanks, yes I found that but I was wondering where I actually put that code?

Hi, In my bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

Hi, I'm making a bookings system and am stuck- yet again! What I'm trying to do now is create the New Booking form. On it you can select up to 10 resources via comboboxes.You also select a start and end time for the booking in the format dd/mm/yyyy hh:mm:ss. What I now need is to assign each...

Thanks, the trouble is the user has to enter the times too. I don't know, has anyone written a popup calendar with time entry too that then feeds back to a single cell?

Hi, My system reads two fields, one with fromtime the other thrutime. These fields are in the format dd/mm/yyyy hh.mm.ss. But to make the system more user friendly on the input form I want to have a date selection box, and start and end time boxes. If I do this can I then code fromtime and...

noooo! thanks. that was really useful. and I will compact the database and clean it up. But it won't really help because I needed 960 toggle buttons which is well above the limit. And then there's the week view, which needs almost 7000! I think I might just need to start thinking of a new way...

Hi I think I've jsut hit the same problem, which is not funny because my project was only just starting to work. I have to create a grid of toggle buttons, a big grid. 2 of them in fact. The first has to be 96 columns by 10 rows so 960 little boxes. The second has to be total 6720! I thought I...

Date/Time Picker error msg "Can't Set Value to Null when Checkbox property = False" I believe this is a common problem- perhaps a fault with the program... I need to have three boxes. 1- Date. 2- Start Time, 3- End Time I thought the easiest way to do this would be to use the Microsoft Date...

haha I think I recognise the start of that code!!! I'm sat with it printed out all around me in the office... actually I have the day form code and the hour form code and am playing spot the difference! I need to extend the toggle grid to contain 2520 i.e so that you can see the scedule in a 7...

Wow. that is amazing, you have actually just saved me!!! Hm yes I've started to realise it's hard too- I'd never seen access before last week but said to my boss I'd be able to do it in 3 weeks. Oops. It's been a steep learning curve! I'm determined to do it though because no one thinks I can : D

Hi. I'm making a booking/scheduling database. Having never used Access before now I'm finding it quite hard! I've done all the forms that feed the database the final task is to display the data in a visual format. In the ‘create booking’ form you enter a start and end time and a number of...

Right, er ok, I have changed the border property to Dialog. Now what do I do? : D ps. sorry for getting your gender wrong!

Thanks gemma, ok how do you open the popup in dialog view or what is the extra code I need to write? Cheers.

Right, thanks. I've made a mock one up to make things easier. The forms are called table = 'Base' main form = 'Mainform' subform that shows table = 'Tablesubform' add form = 'Addentryform' In terms of command buttons I have an Open form called OpenAEform. Private Sub OpenAEform_Click() On...

Hi Dennisk, sorry, I'm a beginner. I tried to put the full qualifyier in to the code to save the addentry form but when i run it it keeps saying: Microsoft Office Access can't find the field 'Basesubform1' refered to in your expression. What exactly should I be writing? Thanks!!

Hi, I see hundreds of people have asked questions similar to this but I've spent all morning trying to copy theirs but I'm still stuck. I have a mainform. In it there is a subform which displays a table. To add an entry to the table there is a 'create' command on the main form. The 'create'...