Search results

Try this see if it's what you want RptDate => Forms![frmDatePicker]![StartingDate] And RptDate =<Forms![frmDatePicker]![EndingDate] Peter Update: I just read from other threads that if your date fields contain pure dates without time elements then "Between...And " will include both start...

Hi Dennis, Are the fields "T", "A", "E" Column Headings of your crosstab query? I believe they are fixed Headings. If yes then open the Property page of your query and enter this line in the Column Headings field: "T", "A", "E" The Headings will appear in the same order as you entered. For...

Dynamic Crosstab Report I had spent a lot of time in searching for better ways to display two dimentional data by forms or reports. I tried to used Crosstab Queries and Pivot Table Forms too, but there was always some problem. Here is some useful information about Crosstab Query, if you find...

See if you can make use of my report method: http://www.access-programmers.co.uk/forums/showthread.php?threadid=59567 Peter

You are welcome. I'm so happy that there's at least one person appreciates my invention! :p Peter

Jim I wonder if you really need a table to store the dates. I think you only need to store the start dates in you database, week number and end date are calculated values based on the start date. Check Help on "Format Function". Peter

register ActiveX Control in Runtime I had similar experience too. Finally I used the Package & Deployment Wizard to make a setup program out of my mde file, included the required ocx file when asked. Run the setup on my client's computer to make it work. Peter

Rose Open your report in design mode, on the main menu select View - Sorting & Grouping, under [Color] group select [Size]. The default sorting is Ascending. This will sort the Sizes in "Alphabetical" order. Then your report will look the same as mine. Glad you can make use of it. Wish us...

Thanks Wayne and Pat, Pat was right, the TicketNo field is a required field and that's one factor that caused the violation of validation. After I clicked OK on my own message box it closed, then the "Violation of Validation Rule" message box popped up, which I clicked OK to close. The cursor...

I have a text box in a data entry form bound to an NON-INDEXED field. I have put in codes to check for duplicates and to prevent input of duplicate data: If (Eval("DLookup(""[TicketNo]"", ""[TS_Collect]"", ""[TicketNo] = FORM![TicketNo]"") Is Not Null")) Then Beep MsgBox "This ticket has been...

Basically my final report is composed of a main report with 2 sub-reports, all based on simple queries. One sub-report displays the Sizes as Heading for Columns, the other sub-report is placed at the end of the main report to show the Size Sub-Totals. If you open the reports in design mode you...

Sorry, This is the 4th time I compose a reply. Everytime I click on the Submit Reply button my browser brought me back to the login page and everthing I wrote was gone and I have to compose the whole message again. Please be patient to view my next post. Peter

In my attached file I use a report with sub-report to display the stock of garments in different colors and sizes. I have tried using pivot tables and crosstab queries, at last I choose this way because it is formatable. Originally I wished to use a form to do so but could not succeed. I post...

Hi, Here is my experience on using barcode readers in Access. The barcode reader (or called scanner) is just a subsitute for the keyboard. When the scanner reads a barcode it's just the same as inputing the text or number from the keyboard. There is no driver required, just plug in the...

If you are entering data using a form put codes behind the Before Update event of the control. I'm not an expert in writing codes so I cannot tell you how to write the codes now. If you need help post again. If you still get no answer I'll try. Peter

I got it! Thanks a lot. Peter :)

But how do I put the WeekDay() function in my code? I mean the correct syntex of using Weekday() in this case. I've tried but could not succeed. Thanks for enlightening me. Peter:p

Hi, Sorry to interrupt. But sometimes simple minded people may find the simplest way to do something. Can this code serve the purpose? If (Day(Date) >= 15) And (Day(Date) <= 21) And (Format(Date, "ddd") = "Thu") Then 'Run backup End If Use nos. 1 & 7 for 1st, 8 & 14 for 2nd etc. Peter :D