Search results

On a form I use option group buttons with the following options Email, Print, Print Preview and Close Form. I will supply sample code if requested.

Why are two people importing the same fiel at the same time or is the imported files different? Should one person be delegated to update the BE with the new import file.?

On the Get Focus event of Item Combobox add the following code DoCmd.Requery "[Item Combobox] " Assuming Item Combobox is the name of your dropdown. Note, you will need to put the name in square brackets [ ] as you have a space in the name.

Sorry I can not help you. Search the internet using "msaccess:storing jpg file in a table". This will give you some hits. If you store jpg in a database then the size of the database increase cinsiderably for each jpg. Now if you use this line of code file_string =...

The data type field to store the location of an attachment must be a Hyperlink.

For your own benefit do the foillowing 1. Document your requirements - this will make it easier for the forum to supply the answers. Looking at your spreadsheet I had just a vague idea in what you are trying to do. It was not organised. 2. Design your tables 3. Normalize the data if possible. 4...

Have a look at this demo survey database for some ideas http://www.rogersaccesslibrary.com/forum/topic3.html

When you click the Login button to bring the Subform back up add this line of code at the end of the code where open or display the subform Docmd.requery "Name of your subform"

To display the final result on the main form use the following syntax Field name= [Name of Subform].[Form]![name of control on subform] Example - Suppose your want to display the current Balance of your deposits and withdrawals from your subform in the Account Balance on your form. 1...

It could be a network problem e.g. too much traffic. Ideally you should have a front end on each user's desktop and the back end on the network server. This will reduce the network traffic in opening the database from the server for each user. Why don't you try splitting the database and see...

The problem is not the line in red, the problem is in your StrgSQL statement. I have not used the following code format as in " AND (Format([InputDate], 'mm')=" & Me.CalMonth & _ " AND Format([InputDate],'yyyy')=" & Me.CalYear & ");" When using SQL the date must be formatted in the US...

You could also look at this site on another forum where I developed a login database. Some of the code could may suit your needs. Look at message 44 has a sample database. http://forums.databasejournal.com/showthread.php?45488-How-to-create-user-login-form-(MS-Access-2000-2003)/page3

If you are using a select query the format for the field in the query should be Script_Lookup: DLookup("Script", "Slc_Campaign_Scripts", "ID='" & lead_id & "'")

xxAdmin = DLookup("IsAdmin", "RATusers", "[UserID]=" & Me.cboUser.Value) Have a look at the above line of code. I assume Me.cboUser.Value is a field on your logon form. If so, you have closed the logon form before you open the "Audit Tool Summary" form, therefore Me.cboUser.Value is not available.

Megamef Prior to 2007 and 2010 when I was at work we used Snaphot format to output a report in lieu PDF Here is a link at Microsft http://msdn.microsoft.com/en-us/library/office/aa188630(v=office.10).aspx

This is a simpler method Store the CSV file in a same directory location e.g. C:\Data\csv on each user's computer. In the database link this csv file to a new table, this table will be refreshed with the each new CSV file relevant to the user. Now use this new table as the record source for...

Empty is not a valid expression, do you mean NULL? Change If Dir(.[ImageFile]) <> Empty Then to IF Not IsNull(Dir(.[ImageFile])) Then

I have not used Allen's code but I use the following code to view an attachment .docx or PDF etc. This displays the attachment in the foreground. The user selects the attachment using a combo box based on the category of the previous combo box. Note, Me!select_attach.Column(6) is the location of...

Hello Natasha You will get a code if you have a record with a value of 0 in your data OR the currentVal is not set. See an earlier message where the currentval is set in the code. I have attached a sample database that will give a minimum value. If you are still having problems please post...

Khalil Using part of the code your minimum function as per previous post. ' Cycle through each value from the row to find the smallest. For I = 0 To UBound(FieldArray) If FieldArray(I) < currentVal Then currentVal = FieldArray(I) End If Next I To exclude 0 from the test we need to add an...