Search results

thanks, will test it out. I will make it invisible and depending on the extension of my file jpg or pdf i will make it visible.

You have a macro in Access called 'Orders' with submacro 'SetFormState' which goes through the form and locks every item one by one depending on the values of the check boxes IsComplete, IsShipped, ect. You need to create another macro that does the opposite and unlocks everything. The...

yes I noticed that with reports, is that becuase in reports in refers to table fields instead of report(form) fields????

Gents, I deleted and recreated the form from scratch, its working now. Thanks I don't know why this was happening, bug perhaps

Sorry forgot to mention, I don't know if this effects it or not. But the form is in continous view. Thanks for any help

I am using 2010, so I am using the expression creater hence I am not typing in the word [Location] but chossing it from a list of fields located on the form. I try deleting and re-adding those fields back into the form, no luck :banghead:

I created a text box with a function for the control source =[Location]*2 where [Location] is a field on the same form (right beside this text box). I get this error in the text box #Name? I know this field exists, it's right beside the text box. Funny thing is it worked yesterday. Any...

When you submit the invoice, I'm guessing you have a button or a check box that tells the database its submitted and edits are no longer allowed. Me.AllowAdditions = False Me.AllowDeletions = False Me.AllowEdits = False You can create a command button that will unlock your form...

Thanks, its seems SendObject will not work and I'll need to do more advance coding

Using the DoCmd.SendObject is it possible to send an email as a task or of high importance so it's not easily forgotten or lost in one's inbox??? If SendObject can't do it, is there a command that can? thanks

I believe if you attach the image as an attachment instead of using the image viewer, it will open the default program to view the attached.

sorry, i just noticed that now. You are correct, that's because the form is continous view, so when the combo box updates they all update. I'll have to play with it later, but I think an Or statement will work. The row source will either be the query or from the same source with no query.

your database is a bit of a mess, I highly recommend you don't put combo boxes into tables and forms, but anyways I think i fixed it. 1.) Fixed Table OrderDetails, field SupplierID. Filled in missing values and replaced numbers with names via combo box. 2.) Changed the source of...

I also want to add that i want to retrieve the names one at a time because I'll have to do a DLookup to retrieve the email address of each employee. I will then have to add all of the email addresses together in one continous string to send the email out. thanks

I have a form with a subform. The subform is in datasheet format and is basically a list of employee. So you add as many employees as you want to a particular form (the form is for inspections). Some forms may have 2 employees and others 4-5. I have a button where you click it and it will...

I noticed that, it's becuase you have a combo box built into the table/query. I have not seen this before, so I don't know how or why you did it like that. You should make your Supplier Query source to the location where the table/query is getting their combo box from. Or don't have a...

your Product combo box has the following source: SELECT ProductList.[ID] FROM ProductList WHERE (((ProductList.[SupplierID])='1')); change it to SELECT ProductList.[ID] FROM ProductList WHERE (((ProductList.[SupplierID])=[cboSupplierID])); try this. Also for Supplier Combo box...

I am looking to see if it is possible to have a pdf viewer in a form. Right now I have the ability to view attached images, but some users may want to attach a pdf file. Also, can the image viewer view the pdf's or do I need to create a new viewer for the pdf files??

I opened the file and I don't know where you are looking at. Which forms/tabs do I need to click on, to get to these combo boxes?

I tried typing it out and access enver asked me to install anything. However I found a work around that seems to work, thanks Const msoFileDialogFilePicker As Integer = 3 Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .AllowMultiSelect = False .Show If...