Search results

I think you'll have to zip it in any event. The sticky in the General forum says that until you have 10 posts, you can only post a zip.

Try grabbing the control in the top left corner to move it individually.

There are a couple ways that multiple users can access your database. The first is to split the database into a front end and back end. The back end contains all of the entered data. The front end contains things like the forms and reports. The idea is that the back end can be placed on a...

I'm not sure how you can widen a column in a form. It may be a datasheet. If it is a form, go into the design view and look at the properties for the control to see if there is an imput mask restricting the amount of text that can be entered. Also, look at the table that you are...

You need to answer AlanSidman's question. Into what are you entering the data that has the field that is too short?

Presumably, you have an After Update Event that populates fields on the form from data selected in the combo box. This code maps the combo box picks to the fields on the form. It sounds as if something is mis-mapped. It should look something like this: Private Sub cboFileNumber_AfterUpdate()...

Delete the combo box and run the combo box wizard again. Make sure that you select all four fields to include in the combo picks.

Why don't we fix the text box first? Delete the existing text box and add a new one. It will be unbound. Highlight the new text box (not its label). Go to the properties sheet, select the drop-down and then select "MedicareNo". Don't type in anything, just select what you're offered. Save...

Maybe I'm not understanding what you're trying to do, but if your form's record source is the "Patient Details Table" and "MedicareNo" is a field in that table, the control source of the text box should just be "MedicareNo". BTW, what is the control you're working with? You stated...

When you say that you created a search, do you mean you created a query? If you created a search in some other fashion such as through a form filter, you'll have to create a query to mimic that behavior. Once your query is in place, run the report wizard and base your report upon that query.

Unless I'm misunderstanding you . . . By "control source" do you mean the name of the table the form is based upon? i.e "Patients Detail Form" If that's the case, the table name is incorrect in your control's reference. It should be: =[Patients Detail Form]![MedicareNo] If "Patients Detail...

You can go to Options, Current Database and select the form to open there.

There is something fundamentally wrong in your design. If the two records you want in the report are in the same table, then the query for the report should draw the data from one table.

I understand what you're saying but am not clear about what you're trying to do with two tables. Not sure why there is a tblModels and tblModels_1. Does your original one record report run from a table or a query? It might be working because your record source in that report is a table(s)...

You're not explaining yourself very well. Since the query is working ok, does the report generate the report with the 2 records in it? What are you trying to trim$?

It's on the Property Sheet that you used to get to the code for the command button, except you need to select "Report" at the top so that you are looking at properties for the entire report. Once you have that view, select the Event tab to make it easier to find.

DoCmd.PrintOut on the Activate property of the report.

Are you getting an error, or is nothing happening. There are two procedures in the code you posted, cmdPrintRecord_Click() and Command53_Click(). The latter has nothing in it. Make sure that the OnClick property is running cmdPrintRecord_Click(). Once you get it working, look for the Caption...

In high-level terms, your report should be based upon a query that returns only the two vehicles that you want in the report. Since you will have multiple criteria (2 vehicles), you'll have to design a form that will accept whatever you're using to specifically identify the vehicles and then...

Some providers let you send a SMS message via e-mail. For example, you could send an email to ##########@vtext.com which would wind up on a Verizon phone as a SMS. Verizon, for example, also allows the user to configure an e-mail alias instead of using the mobile number for the e-mail address.