Recent content by Cwittmaack

vbaInet I'll take a look at that when i get this last report created. tks.

Our company is a 24 hr 7 day a week, there will always be data, but i will look into that "Use form to pull from query and if no data, display no records found and if records found display report" am i thinking on the correct path?.

Got it =MonthName(Month([ErD])) Thank you so much for your help, a lot easier than i would have expected, I guess i was trying to make it harder than it really was. thank you again for teaching me something new.

This report can be run just before 12 midnight or just after, I'm combining 3 databases into one, they had a report for each month, wish i think that only one report should work just need the month they input to place in the header text area just before the static text. Example: January...

OK, bear with me please i'v never pulled information from a query input to display just part of it in an additional location in a report. I have =[Qry_OpShtMontly]![Month] the Query name and field name used. Do i put ,Format[hMonth],(MonthName),"mm") which hMonth is the name of the text...

Pull from the Query like =[Qry_OpShtMontly]![Month] or pull from table. I'm wanting to pull the month that they enter from the query execution and display it with the header text. when i test this it wants me to enter the month again.

I have a query that pulls the records by month and year this worked great Query is set up as Field: Month: Format([ErD],"mm/yyyy") Criteria: [Enter Month and Year (mm/yyyy)] Like i said this works great. But I need the Month that is pulled to display in the report header along side the report...

That is a strange way of doing it but it does work, I just didn't get the name correct sorry, JHB, but I did notice that it leaves the first report open until you have entered all info for the second report. Once you have entered the information the first report will close. Do you have any...

JHB I have tried the code in a another report and did a compact and repair. No luck The Attached DB is a Stripped down partial copy of what I’m doing, this is a database that I have been given to combine 3 other databases into one. The front end is called CENTRAL the tables are linked from...

JHB Will do tks

I am having a problem with the code in the Close event on a report when asking the user if they want to view additional reports after closing the current report in preview. Report Closes after the Yes/No answer is selected. If yes selected it does nothing. If No is selected it does nothing...

user will enter a 2 digit rec # and a 4 digit txid # using a query would like the records to show in a datasheet in sub form. Main form will display what they entered. No data will be entered or changed only view records. the table is stored on sql server I can make a form ato display the...

Is it possable to create a sub form using a single table. I can create one using 2 tables but am not sure on how to or if it can be done using 1 table. All i can find in forum is about multiple tables. Thank you for your help.

Ok, tks will work on it all.

did not see attachment.