Search results

Has anyone seen a sample of a leave tracking database? I am in the early stages of creating one to replace something my company currently has in Excel. We need to track Sick, vacation, personal time and comp time. If I don't need to reinvent the wheel, I won't. If I do - and it isn't ugly -...

I am looking for advice on the folllowing task before I begin it. I have done some searching and haven't found a comparable question. I want to enter the [beginDate] and [endDate]. Once I've done that, I want to populate by appending to a table all of the pay periods in the given time period...

Are there any changes to this when using an autonumbered field (as opposed to date)? When I use my primary key [MeetingID] instead of [Date] I get "No value given for one or more required parameters" I am using Jon's solution. Thanks, Marcus

OK...Thanks...the Immediate Window shows me the output I want. The question now is, how do I activate this for a report or to have it populate a field in a table or query? I am familiar with activating modules with a control in a form, but I don't know how to get the output from this module...

I am trying to convert all the names I have listed in a grouped query into one string record. For example, I am 1) grouping my records by date, 2) each date has a number of records for who was absent that day. I want to convert those names of absentees into a string: 4/1/04 Bob 4/1/04 Bill...

I have an Access DB where I maintain the metadata for data maintained within Excel spreadsheets (I have good reasons why it stays in Excel). I would like to be able to open the Access DB and go directly to the record associated with this piece of data using a VBA input box. For example...if I...

Every file. Actually I found confirmation on MS's discussion boards. It is a bug. They haven't fixed it yet...

Am I getting no replies because I am not describing the problem properly? Because no one else has this problem? or because no one knows the answer?

Win XP/Office 2003, all patches and updates I can find applied. I am importing data as I do on many occasions. While importing, the step where one can change the field name, field type, etc. I have a problem. This happens invariably. I can only modify the first field. If I try to modify any...

I have set up some basic parameter queries for staff. I would like for them to be able to name their report. This only needs to be used once. If they use it again, they can type in a new report name. The format I would like in the Report Header is: Main Title of Report Subtitle of report...

The Totals won't work because if the student were gone 3 days one weeks then gone 1 day two weeks later, I still only have one group and I have a count of X days, but I am trying to get number of contiguous days. That's the kicker. The format () function creates the same challenge. I won't...

I couldn't find anything that related specifically to this question. I have a student attendance table. There is a record for each student, each day regardless of whether the student is Present, Tardy or Absent. I need to group the blocks of absent to count number of consequential days the...

I get that error message. I am creating a data entry form that is tabbed. So, yes, I have a ton of controls on this form. Can I raise the max number of controls?

Couldn't wait. Tried it...it worked.

I've tried this. It gives me no different result.

I have written a report that 1) uses a counter field in a Group/Break section and counts the number of group breaks I have. (set as a running sum - overall) 2) uses a counter field in these same sections that counts the number of indivdual records that I am reporting. (set as a running sum -...

...worked beautifully. Thank you.

I used the command button wizard to create a button to move to the next page (form). I would like this action to also close the form I am leaving. How to do this?

I created a DB for clients of mine. The DB is flat using a some VBA to hide/show Memo fields. Here are my specs: ----------------------------------------- Win 2k SP 3 Access XP (2002) Default DB type Access 2002 Here are my Client specs (2 sets): ----------------------------------------- Win...

Thanks, While waiting for the reply I figured out a solution similar to what Casey was saying. I added a 'count' field to the admit/withdraw query and sorted by that.