Search results

Hello, all. I have a combo box that sorts a form based on an accession number. The accession number is alpha-numeric (like this: 4KF093). My question is this: How can I have the combo sort the accession numbers by (1) the first digit, descending, then (2) the last three digits, ascending. I...

I have a main form that shows project information with many subforms on many tabs. I would like to have a text box at the top of the form that shows the [CompanyName] of the one record on the [frmContactSubNew] subform that is also the [Client]. The Client is designated by a check box. After...

I have a form where you click a command button, and Access appends the selected (proposal) record to the (projects) table. The code then loads the form for the new table. What I can't make the (Projects) form do is jump to the newly appended record on load. It always loads to record (1). The...

I use an append query to move certain records from one table to another. The user goes to the record on the Proposal form, enters the new Project Number (which is the Primary Key on the other table), and clicks a command button to append the record and move to the other form. The code for the...

I have a table that stores contact info for projects: clients and such. I used just a text box in the table to enter the company name, and of course there is wide variation in data entry: lots of companies repeat. Is there any way I can change the text box to a combo box, so people can choose...

I have a query that sorts project numbers with a Mid expression: Mid([tblProject.ProjectNumber],2,5) The second and third numbers represent the year: -02----. How can I use the query criteria to return records for only one year? Or does the >= statement belong in the Mid expression? Help...

Hello. I have a form I use to track survey responses. I have certain questions disappear when certain departments are checked, using the following code on the afterupdate event of the department list box: Private Sub Department_AfterUpdate() Select Case Me.Department Case "Construction...

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

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

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

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

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

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