Search results

You are very welcome.

Put this in the After Update of your text field or within the coding of an On-Click Command Button (whatever you have) to check the check box: Forms!MyFormName![CheckboxName] = True When you want to clear the checkbox, do the reverse using the same procedure: Forms!MyFormName![CheckboxName] =...

Later tonight, I will send a small sample database to show you how I have set this up in the past. Maybe you can adapt the same procedures.

Try renaming and eliminating the space between your directory "stats database" and see if this works. Access does not like spaces when calling directories or file names outside of its environment at times.

Sounds the same as the question posted in the General Section. Look there as I have posted a solution.

An easy solution that I have come up with is to have a small bitmap with the writing "No Photo Available", or if you don't want this, then still create a bitmap, using the same background colour as your form (that way, it will not actual show). I then use this as the default mapping for the OLE...

Is the form already open and you just want to populate it with the record, or do you want another form to open with the record?

Why not keep it simple, if the DCount >1, have a popup form informing the user that there are multiple records for the job selected. Have this form show the records and inform the user to double-click on the record to select which record to view. Alternatively, if the DCount = 1, then no...

In your table for the field, set its Input Mask to Password, this will allow the user to input, but have asterisks displayed. If you want to display the contents at a later date, or within a report, remove the Password Input Mask, or change the formatting within your query.

Unfortunately without a lot of vb coding and nested subforms, it can't be done easily. Thats why I suggested the format of bringing the subform over to the right and having it the full height of the main form thereby at least displaying a number of pictures at a time. Each separate record...

To do this, you would need a subform filtered with the IDRecord as a link. Your subform should be a continuous form, where your recordset would only allow the Top 10 to be shown. You would have to play around with the actual format of the subform if you want it to display pictures. I would...

Go into the properties of your label that you want displayed vertically and set Vertical to Yes. Set the height and width manually. Good luck. [This message has been edited by Carol (edited 10-11-2001).]

I would suggest the following: On the add button, make sure that it is an add button only, and does not include a command to go to a new record, that way, the current record information is still available. Next within the same coding, add a DoCmd to open a Preview Form in Pop-Up displaying...

NEVER store calculated fields within your database. Use a query to include the calculation and then use the results of this query as your recordsource.

On the BeforeInsert of your form, put the following code: Private Sub Form_BeforeInsert(Cancel As Integer) On Error GoTo Form_BeforeInsert_Err ' Set Invoice No to "Max" + 1 Forms!MyFormName!MyTextboxName = DMax("[InvoiceNumber]", "MyInvoiceTableName") + 1 If...

Look into the following: Are my joins performing correctly Is my criteria stated correctly and If duplicate records are involved, should I be using some grouping or totalling for the query

Why inform the user at all that something in the background is going on to accomplish the task at hand. At the beginning of your code on the On Click of your command button, place the following: DoCmd.SetWarnings False Then at the end, set the following: DoCmd.SetWarnings True This will set...

Is this a single report or a main report with a sub-report. If it is the latter, remove the parameter prompt from the sub-report. Also check your query, make sure that you don't have the parameter prompt in both your criteria cell of the field and your overall query.

Might be wrong, but list boxes are funny, and I think that you have to format the row source for your query within the properties of the actual list box, i.e.: SELECT Format([Query1].[Cost],"$0.0000") FROM Query1; This will get you currency values with 4 decimal places.

What type of files do you need attaching, and in what way do you need them attached. More background needed.