Search results

I have some code that runs some code to add a foreign key to a sub-sub-form. To refresh the foreign key data I also run a requery. The code also saves the record. The sub-sub-form is now reset back to the first record of the related records. The problem I have is that regardless of which...

Access 2003 I have a form that is designed for semi-technical and non-technical to enter budget plans for the upcoming year. The form is based upon 5 primary tables/objects (Employees, Trade Associations, Membership, Conferences). Employees: Trade Associations:1 to many with Employees...

I have a SQL 2005 DB with 57,000 accounts and a huge quantity of activities (emails, letters, phone call, etc.) related to the Accounts. I want to find the accounts where there is at least 1 activity...not the number of activities. You can imagine the time it takes to pull this data! Tbl#1 -...

I have a number of .TXT files that are output data. Each file is formatted as 1 long string of characters. I have sourced out some code to add CR's every 100 characters. I will need to modify the code for each file because the spec file for each is different (some are 513 characters long, others...

I am using an update query comparing 2 tables to add new records from table 2 to table 1. This worked fine until we upgraded to Office 2007. Is this a function of 2007? I am not getting any prompts to OK, "You are about to update 1500 records" Thanks for any help. -Marcus

I am experience brain flatulence and need some remedial assistance. I am creating a data entry form. I have envisioned a tabbed format because I will have this idea utilized for Placement, Mentoring and Seminars data entry as well as recruitment. But I am open to other methods. Here is a...

I thought I saw this problem solved before, but couldn't find it in by searching. I have all the megamillion lottery winning numbers. I have them broken up into their positions (1st, 2nd, 3rd, 4th, 5th, MoneyBall). I want to take the flat record and turn it into a relational so I can do some...

I am using Access 2003, Outlook 2003, Exchange 2003 I am developing an Access CRM. The DB uses a linked connection to the Exchange server to populate the contacts table. The contact folder used is Address Book in Public Folders. To create new contacts, it seems easiest to simply open a new...

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...

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...

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...

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?

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 -...

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...

I have a form that uses two tables (Pupil ID & Admit Withdraw). The list of pupils attending a specific school (Pupil ID table) is the main form. I have a subform which displays the admit/withdraw history (Admit Withdraw table) for that pupil. Everything works fine except that I would like to...