Search results

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

I have a form that accepts credit card information. The user wants this to open with a button that asks for a password so that only those with the correct password can use the form. I am sure this is something pretty simple, but is eluding me. Access 2010, windows 7 Thakns for any help, and...

Shadow, thank you so much for your answer and the link to your answer to someone else! You hit it when you mentioned all the extras the client thinks of afterwards, especially additional reports that would be built on existing queries, but the forms they open have already been coded, so instead...

This is a very general question, and any insights would be appreciated. My work venue has changed, and I working for someone who has clients, and needs an Access database (A 2010). My boss wants a proposal stating what has to be done, and how much it will cost. I do not know how to make a...

Thank you, mahenkj2, for your quick reply. Yes, my form with the 3 text boxes to collect the user's input is in lieu of a parameter with 3 separate boxes popping up to accept user input. I have the 3 boxes on one form and the user will enter a name, a state and a zip. Then the form based on...

I have a an unbound form with 3 text boxes which I created as a modal dialog form, and I'm pretty sure that's waht I need. The user will enter text into 3 text boxes (and one of them should really be a combo box) and the main form based on the data table should open displaying only the records...