Search results

Worked like a dream. Thanks, Tony.

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

Thanks for your help, Rich. I think that will work. Margaret

Thanks for the code, but it wasn't quite right. It populated the text box when the check box after the update, but looking up records the check box was blank. Maybe if I refresh the checkbox when the record changes, it will work. Can I make the code pull whatever value is there, passively, and...

I have been able to pull the CompanyName from the subform with just an =[CompanyName] expression, but it pulls the first entry in the subform. What I need is for the value in the top text box to be constrained by the value of the [Client] check box. I guess what I'm looking for is the equivalent...

Yes, the company name is one of possibly several entries on a subform on the "Contact" Tab. The "Client" check box is also there. I want the Client name displayed at the top of the form (off the tabs) for ready reference, but the data entry will still take place on the subform.

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

Thank you, thank you, thank you, Pat. As usual, your answer was right, and so simple! margaret.

Thanks, Mile-o-phile, for the tip. But it didn't solve the core problem, which is making my main (projects) form jump to the new record. I think the source of the problem is that the (projects) form opens with the data sorted by a Mid() expression. That would cause a new record to appear in...

Not quite what I need It didn't quite work. I pasted the code after the code to open the form on the (proposals) command button (see below). The (projects) form opened to a record in the middle of the table. Would using the DoCmd.GoToRecord with link criteria work? Thanks for your help...

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

Many projects, many companies, many people within those companies working on many projects. I had tried to branch people off from a companies table (one to many), and link the companies to Projects (many to many) and nothing worked. All I need now is a standardized list of names for people to...

They enter the data in a subform, to be exact. The idea is they'll choose a company name from the combo box, then enter the other contact data. There are all sorts of combinations of companies, contacts and projects, so I am worried about referential integrity problems. Do I need to make 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...

Worked around. It wouldn't let me run criteria in the expression field, so I put the following in the Project Number field: Like "103*" Or Like "203*" Or Like "303*" Or Like "403*" A bit long, but it worked and I'm not complaining. Thanks for your help, Margaret

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

Problem Solved! (I think.) No, that didn't work for some reason. Thanks for your help, tho. What did work was a refresh button from the command button wizard. I pasted the code from the list box before the refresh DoCmd. It made all the necessary fields disappear automatically when I click...

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

It never did until I added another command button... I had been into design view before that, and the application didn't close. M.