Search results

Exactly, I do not want anyone to have access to the table. How can they view past records without see the table is the question. Should I build a form or report? Which one allows a user to filter to the specific record they are looking for? I am thinking it will have to be a form - but I am...

I have created a database in Access for my department and limited the users to only specific tables based on their need and role. However, users have expressed the need to view past work. I do not want to give them access to the table - I am thinking that there should be a way to create a report...

Anyone have recommendations on training classes in the Chicago area or resources were we could advanced through the levels?

No idea why my previous post is gone... Unfortunately I do not understand what you are suggesting. New form comes from Table 1, one field on the 'New Form' is for the user to enter a specific code that relates to information on Table 2. I would then like to add a field on the 'New form' that...

We have created a database where data entry happens on the first form. So far all is working well on this form except users complain there is not enough space for comments. I set up a column for comments, but it is limited to 255 characters. What/How else can I set this up to provide a lot more...

Once the fields were added to the query I added them to the form. No, I do not know how to open a recordset. Previously I built a relationship and added the field to the form and the relationship populated the added field once the first field was filled in.

Yes, I have created a select query which takes the relationship data and enters the four fields needed. The query works fine. Then I went to the form and added those columns to form options, but it is acting like a filter and not allowing new entries.

Post 9 was to clarify post 7 but I failed to state that we do have another table that only houses the salary lines and is updated via excel weekly from our seperate payroll system. This issue has the highest priority, with e-mails being secondary.

We would like to create an e-mail button to send just the current screen shot but are having issues with that. We also like the e-mail auto apply responses feature but are unable to create a button for this.

Let me try to be clearer: We created an access database to streamline our department and maintain history on our work. We had a 12 step process using word, excel and outlook that we were able to change to a 3 step process using access. Step/Form 1 is used by analyst to evaluate/rate a new...

We are creating a new position via a form from a new build table, each new position must use an existing salary line (have a table of all salary lines). The salary line table contains four columns that need to be added to each new position based on the 'salary id #'. We know by looking at the...

I do see now that this would expose our data to unintentional changes. Can we protect fields on forms - to only show information but not be open for changes? Would it be possible for a user to enter data into a field on one form that would auto populate a field on another form with information...

While I understand the concept - I have no idea how to execute. In my master table I made the schedule (to be given via form by operator) a combo box from the secondary table. So how to I connect that retrieved information to the necessary column in the master table?

Hello - I am developing an Access 2010 database from scratch and am in need of assistance - we are looking to create two auto population fields. First - fields Sal Min, Sal Mid and Sal Max to auto populate when the schedule is entered. We have two tables PED & Salary Range, one being completed...

I am a new access developer - used it before but now am creating one from scratch for process improvement at work.