Recent content by jojo

Perfect! I used Allen Browne's, creating a table containing the deleted records, any edited records with 2 versions before and after, and new records all with the date/time stamp and username as part of the record. Awesome! Thank you to pr2-eugin for the great answer. Jojo

Thank you gamma-the-husky for your answer of 3/1. The problem with the date picker is that the dates would be a different month and year, and would require much time-consuming arrow clicking to get to the right year and month. Thank you for replying! Jojo

Thank you, John Big Booty for the answer about the date formatting you posted back on 3/1, which I just discovered. It's hard to understand how Access doesn't have the capability of accepting a date formatted as mm/yy. I am using mm/yyyy, which is more bother for the user to have to type in...

thank you, BigJohn Booty for your answer on 3/11 which I only saw now, because your reply went into the spam folder for some reason! Yes, you are right: I have 2 queries with similar names, and was using the wrong query name....which happens when noviecs work late into the night against...

I am not sure what you mean by 1st pass, 2nd pass. Do you mean add columns to the newly created Acc table such as EmployeeId where EmployeeID matches the name in the main (parent) Employee table? If i add this column, what will it be populated with so that the right record will match the...

Thank you for that also, that was my next question! I have other parts of this project that need to be done immediately, and this import has to be done later on, but was just thinking about how to go about it when I do get to it, so it might be a couple weeks but I will let you know! Thanks jojo

Wow!! thank you so much cj_london for your quick reply. When you say "passes through the spreadsheet" do you mean the XL spreadsheet or the Acc table into wihich the spreadsheet will be imported? I see this well take some time to implement and fine tune. Thank you again.' jojo

I have an Access database with related tables and lookups. The data for the tables is in a large Excel file with about 100 columns and 30,000+ records, which will be imported into one flat Access table. This table has to be imported into smaller related tables. Each record contains all the data...

Thenk you, pr2-eugin for your qick answer, and for the link. I plan to try coding that, and will let you know. Thanks again. I have found so much helpful info on this great forum. thank you all! Jojo

I am writing an Access 2010 program for a small business. They want the ability to track the actvity logs of users: if they added, deleted or edited. Is there a capabilty to do this in Access? I knw there is a macro that could be set to show the most recent user, but I don't think it could...

Thank you so much, DavidAtWork for your reply about strComp. That is a good strategy to keep in mind for other, less sensitive information needed on forms. Does that mean that if you're getting the string from the user, you have to hard code the correct string? Is there any other way?

I am trying to use Dcount to find the number of records in a query and put it on a text box in the header of a report. The query is a parameter query. The button opens a form which asks for start and end dates, the query reads those dates from the form and the report displays the correct number...

I can't get a date field to display the month andyear. In the form format box, I worote mm/yy. when i type that in the form it interprets 8/15 as august 15 2013 instead of August 2015. this should not by hard. Thank you to all of you for your wonderful answers! Access 2010 win 7 jojo

thank you again for taking the time to reply! In our setup, the BackEnd is always on a secure server and the front end on each user's local drive. Would that be secure enough? They could give the one or 2 people that handle credit cards the form on the front end, and keep it off the other...

thank you for your timely reply. Yes, our organization is rethinking its plan and our project manager is researching the options. I guess it would be useful in general to require that some forms are not available to all users, and should require a password to open. is that possible.? Access...