Search results

OK, I am doing a humangous query and all kinds of dlookup. My main query table is tbl_groups and I am doing this. I have field called PYE(date field) and I am using this ||Year: Format([PYE],"yyyy")|| so I can filter by year. Now I am doing a DLookup to bring some values. I want to bring...

Text Properties.... Go to Text Properties > Format > Can Grow=yes > Can Shrink = Yes. It works for me.. Good Luck Dianna Goldsberg

Move this to sample... I guess you can put your code in the sample folder. Good Job. I did something similar but my code pulls user from the system. Good Job.

me.opt1 = null On Save event me.opt1=null or me.opt1="" I dont know if thats satisfy your needs. Good Luck Dianna Goldsberg

Not on the List.... I am not if I understood your concerns. Assuming you have a combo box and If the user name is not listed you want user to type their and retain that value in your table. If I am on the right tract then you can user Not on the list event. Please see my sample.... (also you...

set focus.... have you tried set focus. you may need to tell the system to look for current record by max autoid or max date and then set focus to that record. do a seach on the forum there are tons of set focus sample. good luck dianna goldsberg

Similar Method..... http://support.microsoft.com/default.aspx?scid=kb;en-us;146310 ------------------------------------------------------------------ You can follow similar footstep. Upon opening the report you can pop up a form with txtCurrentDate and default that date to today's date now()...

Try this link.... http://www.rogersaccesslibrary.com/download3.asp?SampleName=ChooseReportFields.mdb

Choose Report Fields... This is a wonderful sample for Choose Fields for Report..... This particular sample has a limitation of 6 fields. However you can change the code and not set any limits. Code for unlimited Fields ======================================================= All you really...

Now and Date Functions.... >=(Now()) And <(Now()+7) >=(date()) And <(date()+7) I tried both and they seems to work. Make sure to you have some data that impact this query since, You are pulling anything going forward. I tried less than it worked. I tried greater than and I did not get any...

more info... I am assuming you are using this code on your second form. 1. are you closeing your first form befor gong to the second form or you are setting visible = false. preference visible = false, and on exit second form you can set [forms]![form1].visible=true. 2. I am using plenty of...

List Box Search.... List Box Search....

Drop Down Search.... drop down search...

try this... This code can go either closing ur second form or if u have save or close button on ur second form. DoCmd.close ' second form Forms![frmMain].Visible = True ' assuming you are hiding the main form when you are opening the second form Forms![frmMain].Requery '...

Format... Is your 3rd Text Field where you calculating A+B set to correct format. I mean Format should be Fixed and decimal should be 2. Good Luck Dianna Goldsberg

Weekend Formula.... 1. Do a search for "count weekend" 2. You will find some neat suggesion and help. 3. you can then put [date1]+[date2]-[weekend] Good Luck Dianna Goldsberg

why r u aggregating ?? If you are using Sum then you dont need to aggregate (meaning using the Total from the View Menu). I just ran something similar and it worked like charm. and field name is whatever the date field is. (so if you want all the record from a date like, 3/8/04 and ur field...

more info... http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=Crosstable+query+returns+too+many+records&btnG=Google+Search Good Luck Dianna Goldsberg

total query 1. you can do a total query or put a sum in your query. sum: sum([regularTime]+[overtime]) 2. dont forget to put [enter a date] under criteria for the date field. and then click on the datasheet view. the system should prompt you for [Enter a Date], put a desire date and...

Advance Audit Trail... This sample database is even more advance than my first post. Check it out at you leisure. Regards Dianna Goldsberg