Search results

I tried that, but I'm not doing something right. Instead of: Forms!frmClaims.customerID = Me.customerID which works great if there's an existing record in the subform, I tried: Forms!frmClaims.customerID = Forms!frmCustomers.customerID where frmCustomers is the main form, frmClaimsList is the...

OK, that worked perfectly. But... It doesn't work if there's not already an existing record in the subform. I get an error "Syntax Error (missing operator) in query expression '[CustomerID]='. Any ideas?

I have a form with contact info, which also has a subform with other data on it. The subform is a continuous mode form. If I go to the "New" line (last line) of the continuous form, I can add information, and the records are linked via the customerID field on both the form and subform. I...

I have a database with a macro that runs a batch file. That batch file is supposed to take the backend database and use the command line version of WinRar to compress the backend, and then invoke a command line email program to email the compressed backend to me. If I go to the Macros page of...

Gemma- That's exactly my problem. This subform is the same one you helped me on in the VBA section. The one that scans a directory and lists the files in it. It's set up to scan the directory of the person in the main form record, but the underlying tables for the form and subform are...

This may be a simple question, but I'm not sure what to even search for. I have a form with multiple subforms. All the subforms have related fields that are linked via relationships. But one subform has no fields in common with the parent form. I need to be able to have the subform update...

THANK YOU! That worked great. And I think it was one of the best responses to a question I've seen. You explained it perfectly.

Hmm. I thought I tried that and it didn't work. I guess I must not have been doing it correctly before. But all is well now. Thanks. Now here's another wrinkle to the problem. One of the variables I'm trying to set is CompanyName. In my form, I have a combo box that displays the company...

I'm trying to use ghudson's File Browsing form on a subform on my main form. The code is written to have a static file location to look for files. I want to make that dynamic based on the record that I'm viewing. I thought about doing it via VBA, and taking the value of the Parent Form's...

Anybody have any idea? I have a feeling it'll be something simple that I should have figured out.

OK, I think I'm trying to make this harder than it really is. I realized I don't need to have multiple cascading combo boxes for what I need. All I really need to do is have 1 combo box that only shows policy numbers for that particular customer's ID. This code works perfectly for the row...

I'll give that a try. But to clarify my setup per your questions, I know that there will always be 2 leaders. And each person has a related record with a Team Name. Those 2 leaders would have the same Team Name and nobody else will. So what I'd want to do is test the team name, and each name...

I have a feeling this is a common and probably easy question, but I couldn't find anything on it in the forums. I have a main customer form with multiple subforms on it to keep track of my clients insurance policies and claims. I enter their contact data in the main form, and the policy data...

Is there a way to take data from from individual records in a query and assign them to strings? For example, I want to do something like: Name1 = qryLeaders.Name.record_1 Name2 = qryLeaders.Name.record_2 Then I would be able to say something like "Please contact " Name1 " or " Name2 " if you...

This works great! Any idea how to make it send batch emails? I'd like to send confirmation emails to 50-60 people at once.

I have a report that is basically a form letter. Each page is an identical letter to a different person. It functions just like a mail merge in Word would function. Right now we mail out these letters. I'd like to be able to email them instead, which means I'd have to save each individual...

I have a form that has a combo box with a list of selections. I also have a tab control with a tab that corresponds to each option in the combo box, so that I can show the details specific to the selected item. Is there a way to have the value of the combo box select the appropriate tab in the...

Is there a way to do this, and also have it automatically send an email to each individual person, with just their section of the report?

I have a database that I've created for someone else to use. It's split into a front and back end. The user will be placing the front end on her desktop PC and the back end on a network server. She also will be taking the database home to use from time to time. My problem is that when the...

Here's the layout of the report(s). Page 1 has a lot of data from the database on it, and that page works fine. Pages 2 and 3 only have a picture on them--no data from the database, so those are of course not an issue. Pages 4 and 5 only have 1 text box on them. The text box is also on page...