Recent content by Poot

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