Search results

Thank you I have now in my cancel criteria: Is Not Null And <=[Arrival Date]-28 ...which would appear to work... Thank you for your time and expertise. Very much appreciated. Regards, Poot. :p

Hello, I am trying to run a report from a query that will show me cancellation dates that are 4 weeks before an arrival date for my booking system. I have a cancellation field and I have an arrival field. I have in the query "Is Not Null" as a criteria for cancellation so as only to pick out...

Yay! Thats the one... something so simple!! Thank you. +karma to you!! Regards, Poot.

Hello, I am trying to run a query that will only pick up records that have a specific field filled. i.e. i have a field that will be filled with a cancellation date uopn someone cancelling a booking. My problem is though that when I run my query it just picks up all the records... how can i...

Compact I had the same problem when trying to post a bare-bones db. Goto: Tools > Database Utilities > Compact and Repair Database and go for that... squidged mine down to a nice size that I could .zip and post on here. HTH. Poot.

Thank you. You've given me a good direction to work in. Cheers, Poot.

bump Hellooooooooooooo...........??

I believe.... No worries...Ancient One.. and thank you for taking the time... That sounds pretty much like what I am after, and I would be grateful if you would send that on... Thanks again. Poot.

DoCmd Hiya... you want to add in on your form when opening: Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , Me.Name, acNewRec End Sub This will open your form at a new blank record... your user will then be able to scroll through your records if desired. HTH Poot.

hmm Well... i was thinking that the "single form" would look better.... but if it's going to be exceptionally hard I'm not sure anymore.... Are you able to populate the rows, leaving the design as is, using SQL or does it involve VBA? I was just wanting to be able to see all the room details...

okay Hi ... I have attached the bare bones tables and forms that I am having problems with... tables are populated with nonsense so far but shoudl be enough to see what is what... the subform has buttons added that are to be removed -- they allow you to move around the records at present...

Thanx All the premises are correct so... In "companyTable" = parent.Form In "availabilityTable" = subForm Relationship 1:many from "companyTable" - "availabilityTable" using companyNumber as Primary and Foreign keys. Is where I got confused... would have thought yes I would get the five...

bump Hiya, I am attempting to only allow the user to cycle through the records that they have specifically chosen using a combobox. What I have achieved so far is a form with a subform. The form allows the users to choose a company name thus bringing up their records. The subform then...

?!? Not sure either since not enough info on your tables.. but you can take info from your intentGradTable to your grad form by setting up a subform within it with the subform control source as the intentGradTable and setting your textfields to be controlled by the relevant records. HTH Poot

Saving Using the button from the toolbar and choosing the save button will allow your user to save their current record. Doing this will be automatic and you don't have to worry about code... though it's along the lines of... DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

Possibly? I'm not entirely sure since I am relativily new to Access but... me.requery ....might me along the lines of what you are looking for. Sure this will work in a multiuser environment.. though...well....

k Ok... my problem being is that I have a form (form1) and am choosing a company by using a combobox. I then goto the subform and choose a date (from combobox) and the records - 5 records for each date - would ideally come up. What I have is: A continous form...... ALL records come up...

Hold on... Nope.. I have tried that and it is the same problem.. only this time I get my results but it is all of them.... my combobox now only takes me to the first record with the value in the combobox!! I would ideally ONLY get the results in the combobox....

Aha.... Thank you.. something so simple as "continous form" -- heres me with a sore head thinking about answers that are needless and lengthy!!!.. I think I should go and buy a large book! Thank you!

Hello, have 5 text boxes that upon choosing a date from a combobox fill with data from my controlsource. However, all boxes fill with the same control souce... I would like the next one along to fill with controlsource+1, then controlsource+2, etc.. so that I can have all of my data on screen...