Search results

Yeah, I know its not preffered but it is what was requested of me to do. I didn't think there was a way to do it the way access is now. Its good to see that this may be possible in 2010. I need to do some research on the new features. I wasn't aware there was documentation available yet. Thanks...

I have a continuous form that has a unit field and a price field. There is another field that calculates the unit quantity times the unit cost.. Is there a way to check the value of a calculated field before a you enter a record and then check to see if that value changed before the record is...

I usually run my access automation from VB Scripts and I have the scheduler activate the script instead of the database. Here is the code that I am using in case you would like to try this method instead. You can put the code in a notepad document and change the extension to .vbs . Gregg...

Is your database on a network and is it spilt?

Paul, Yes I can! This is a great solution. Thank you for solving my problem. I do have a email table that has the username in there so I can have it entered in this way. Thank you again for your help. Let me also let you know that your previous posts have helped me greatly in the past. I will...

I have an access 2003 database that has a approve/reject email procedure. If someone approves a job, they click the approve button and an email in outlook will pop up with a set message. I would like to know if it is possible to put a link in the email that will send the person to the copy of...

I use the scripting edition of Imacros. The free version will not give you everything that is needed. http://www.iopus.com/ Gregg

The link below fixed this same type of isse for me. Hope it helps Gregg http://support.microsoft.com/kb/945674/

I'm not familiar with the .display command. I rarely use listboxes. I just remember the last time I used one, it was based off of a combo box. After i ran the code on the after update on the combo box, I used the requery command at the end and the proper items appeared on the listbox. Sorry I...

Quick guess. I think you just need to requery your listbox upon entry. me.listbox.requery Gregg

I am trying to get the file path from a linked ole object in my database. I am using code microsofts website. Here is the link to the article. I have listed the code below. http://support.microsoft.com/kb/199066 I am able to get the code to work, however I am having a problem when a folder or...

I'd be interested in seeing some of these functions if you have the time. Thanks Gregg

You need to specify in the code what how you want to open it. Try this: DoCmd.OpenForm "GUGraphFilter1", acFormPivotChart Gregg

It looks like you sent the wrong file. You most likely tried to send a shortcut rather than the actual database. Gregg

Try this out. I took out the notetable join in Query2 to show all those records that you need. I then made Query3 which is using joining query 2 and your notetable query but showing all records that were in query 2. Gregg

I cuurently use a program by a company called iopus called Imacros to send data from my access database to a website and vice versa. In order to use it with a database you would need the scripting edition. Here is the website for the product. They have some examples tutorials on the site as...

No problem. Good luck.

Sorry about that. I forgot to add the dame code in the criteria in the record source. Try this one.

If you choose the Option group, not the option button, there is a wizard that will walk you through setting this up. Hope this helps. Gregg

Try this out. I took out the autonumber and made the default value of the lead ID whatever is being shown in the Lead Information form.