Recent content by Derrick T. Davidson

Hi arnelgp Here is a condensed version with relevant details and a quick explanation on the opening page hope this will suffice? I hope it is attached never done this before :)

Do you need the complete database or just the query and report? The database is rather big, the report is rough (in the design stage). I found the code below on the internet but it stalls at "Count" not the correct code? Private Sub Report_Open(Cancel As Integer) RecordNumber =...

I have a report which derives its information from a query. The report is a summary of cargo going out per day, and works fine. My problem is there are 20 entries per sheet and if I have less than twenty the report cuts off after the last entry. Is there a way (besides adding extra zero...

Great thank you once again

Hi All, I have a form [frmCountryFlight] which has 8 check boxes what I want to do is: If [cbDaily] is checked then all the other check boxes [cbMon], [cbTue], etc. automatically check to yes. Otherwise selected days are checked. Is this possible?

Hi I have purchased a new copy of Office 2016 and it has all the bells and whistles, including SharePoint. Through the good help here I have built a desktop application that does all I need. Now I look into Web Versions and find I have to start from scratch with new ways etc. This is...

Great working now thank you

Still getting the message??

I have an event on the not in list which opens a form to add the item. However I still get the access message the item is not in the list. I have tried set warnings to false however it either doesn't work and the message appears or if I include it in my code it says this is not an option, my...

Hi All I have a form [frmTransaction] which contains a Sub Form [frmSubTransactionDetail] I have the form working great thanks to help here. However I have a new issue. When I click on a control on the subform [Brand] if it is not in the list it opens the form [frmBrands] and I add the item...

Hi When I have multiple stacked text boxes I was wondering if there is a method (similar to excel (ctrl arrow down), etc.) So I can select more than one text box in the middle of a stack?:confused:

You are sooooo good man thank you

My second post as the first was so good: I have a form [frmSuppliers] containing a sub form [frmItem] and a text box [Item]. When the suppliers name is entered the sub form appears with a list of items provided by the supplier [txtSupItem]. What I would like to do is click on an item...

You are the best thank you so much

Hi All, I am new here and not an expert in code. My Question, I have a sub form containing a sub form; I have a sub form [frmSubTransactionBalance] which I have placed a button [btnStatDate] When I click the button I want: The txt box on [frmSubTransactionBalance] [trStatDate] to...