Search results

Ok, I don't know what I managed to do. I had a bit of code on the On Close event of my main form that closed Access when the main form was closed (DoCmd.Quit or similar). I had it there to avoid a security hole. It worked fine for a time, then I added an invisible command button to my form...

I have a db that is set up on workgroup security. The database opens to a main form with tabs and subforms, which reflects project data. I set a number of users to Read Only, but when I log on as a read-only user, none of the subforms are visible. The datasheet subs are empty and the form...

Ok. I have several users set up now with workgroup security, and I mostly understand how it works. There are two admins, no permissions on the User group and Admin is only a member of users. That should take care of 1-5. For 6, I used the code below: Private Sub Form_Load() If CurrentUser...

My problem is this: If I boot access and my database, I log on with my password and it pops to the main form... as normal. But if I close the main form (thus the database) only (not Access), I can open it again from the file menu, and it opens the database window without the password prompt...

Enter data for query/report The real problem here is that the billing info comes to me on paper from accounting, since the accounting software is compatible with nothing. Otherwise, I'd just pull in the table data. What I need is a monthly report for all projects, and I have no need to store...

I have a query that pulls data from many tables to display project info, status, proposed values, etc. I want the user to be able to enter the total amount billed for each project, then print a monthly report that calculates percentage complete and totals. My question is, where should the...

It's time to implement my shiny new database, which will involve putting it on our network so users in many departments can access it at once. I need the permissions because I want only a few users to be able to enter/change data and the rest to view only and run queries/reports. I ran a copy...

Thanks for the lead! My coding skills aren't stellar but I think I can muddle through this. Margaret.

Hello! I'm not quite sure how to do this, but here's what I need: I have a form with three tabs- a main form and two with three embedded subforms. After the initial record creation, if any of the tabs or subforms are updated, I want a subform to pop up requiring entry of initials and a change...

The code bit worked! Thank you, Margaret :)

I have a command button that is supposed to open a form in datasheet view and show a list of records... nothing complicated. The problem is that the form will only open in form view. I have even set the form so that only datasheet view is allowed. If I open the form directly, without using...

I must be missing something. I put the Where clause in a select subquery to retrieve location codes, and get either no results at all or a message that only one record can be returned. The query should pick up the value of the record on the active form, compare it with similar records in the...

I have a text field that holds a location code in the format >LLL/-000. The letter and number parts refer to coordinates on a big map in our office. I would like to have the users able to search for similar records by either half based on the LocationCode value in the frmProject. Do I need...

It Worked! Thank you, Tim K., It worked like a charm. I had to specify the table because of the nature of the query, so it looked like this : mid([tblProject.ProjectNumber],4,3). I applied the same to the Record Source query on my main projects form, and it worked there, too. Thanks! :D...

I have a list of projects on a report that I need to sort by project number. However, our project numbers are composed of a location number, then two numbers for the year, then three ascending numbers and a department letter (example: 602113E). The question: How can I sort the report by the...