Search results

Posting this mostly to help me think through the issue but feedback would be appreciated. I've split my database into front and back-ends. Previously, I had a separate utility that clients would have to run to update the back-ends. I'd like to move that work into my front-end but I'm having...

Background: I currently have two tables, orders and payments. I need to track payments in their own table for accounting purposes. I was keeping a running tally of the balance in the orders table and updating it whenever a payment was made (I also set a paid date when the balance reached 0)...

Since the document is already open (if its going to open) in the doupdate function, I changed the doesexist and updatespecificfields functions to take the word document as a parameter instead of the filename (that also speeded things up considerably). DoUpdate - takes a property and the new...

Is the record open in more than one form? If so the other form could have the record (or depending on your row locking setting more than one row) locked so this query can't do the update. -Lution

solved: Unable to update word document 2nd time through When the user updates an option in their database, I'd like to push that option value into the user's merge documents. I've omitted the call to get things started but I basically call DoUpdateFileProperty with the property name and the new...

I didn't have any trouble getting the location of MSACCESS.exe from the registry, there were plenty of examples on the web to use. To be clear, I'm not using workgroup security on the database. I'm opening the database in exclusive mode and using the Encrypt database option that is available...

I was following the details in the original message up until he recommended using a vb application to use shell to launch the Access application. I've tried & tried to get shell to work with an Access 2007 database that's been encrypted but I've had absolutely no luck so I ended up using the...

I want to lock my users into using mostly my command buttons and a few of the standard ones so I've created my ribbons and set startfromscratch="true". I've assigned the custom ribbon to my forms, but if the user selects "Filter by Form" my form ribbon goes away and it sends the user to my...

Thanks for checking Bob. I'm in the middle of making a release build of my project and got worried my system was infected with something I couldn't find or detect. Safe travels Lution

Here's a copy of the database.

I'm using Access 2007 sp1 on Vista and noticed something this morning when I created a new (completely empty) database - after closing the database and reopening it, I get the security warning that there is a macro in the database. If I tell Access I trust the database and open it, I can't find...

Thanks pbaldy, that helped me find what I was looking for. I wasn't using the correct property name. I also had to play with the string format some to get it to work. End result I created a function: Public Function SpecialEffectExit() screen.activecontrol.SpecialEffect = 0 ' set back...

I have a listbox with 2 columns: an error message, and the form control with the error. The 2nd column is hidden from the user. What I'm trying to do is when the user clicks on a row in the textbox it will setfocus for the control with the error. That part I got to work but even in my simple...

Anyone created a date control on the Access 2007 ribbon bar? I've been looking for an example but haven't been able to find one. Thanks Lution

No, each user has their own front and back-end.

The code I showed was the only thing in my forms close event. I don't apply/set any filters in code (there is no filter/onfilter event code for the form or any controls on the form), its all up to the user to use the UI built into Access if they want to use them. I had several users get into...

I have the following lines in my forms OnClose event: ' Make sure to clear any old filters Me.Filter = "" Me.FilterOn = False Me.OrderBy = "" Me.OrderByOn = False However, after closing I open the form in design view and whatever the user's last filter and order were are in...

The URL pointed to in the previous post has changed: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=619856&Zf=&Zw=UpperCase%20converter&Zg=0&Zl=a&Main=619856&Search=true&where=&Zu=15840&Zd=l&Zn=&Zt=e&Zs=b&Zy=#Post619856&Zp= Just in case someone else goes looking for it...

See: http://www.access-programmers.co.uk/forums/showthread.php?t=139645&highlight=report+hide

I just realized that it is working correctly and hiding the field when I go to print preview, I was just looking at the Report View. <<bonks head>> Is there a way to hide it in report view too?