Search results

Hi all, I kept working on it and found this to work =CInt(Format([text0],"y")) . I think my subsequent queries didn't like the fact that when I chose to format properties for that object as Date/Time "y" it was still a Date/Time format. The query I subsequently run using this value as a...

Hi Adam, The data doesn't get entered into any table, it is just a data holder field on a form to run some parameterized queries after the click of a command button. But, yes, I just want the date 1/1/YYYY to become the integer "1"; 1/2/YYYY the integer "2" etc. This way, I can run queries on...

Hi all, I have an inherited database with years worth of julian dates stored as numbers (e.g. days 1-366 for a leap year). I also have some fields stored as short dates. I would like to run a series of parameterized queries on this data, some using the short data and some using the "julian...

Hi, I have a several parameterized queries that I would like to run using the same information, but don't want to make the user enter the same parameters over and over again. What I envision is the use clicking a button to run a macro that will run each query and then open a report with the...

Hi CyberLynx, Thanks a bunch for the code! It worked like a charm. Cheers, Peter

I am new to VBA and am having some problems turning several fields on a form off and then turning them. I was wondering if I might get some help with my code. I have a master form (frmSurveyType) with a combo box (cboSurveyType) with a tabbed sub form on it (sbfNestSurvey). When cboSurveyType...

Hi I need help creating a module in access but I know very little VB. The module will calculate time continuums that will be summed later to get total effort. Here’s the scenario: two or three people record start and stop times when observing a colony. There are many start and stop times in a...