Search results for query: *

Just wanted a simple way to modify the "Where" Clause of a Query on the fly so that I can just send a Range of Records to an Excel file using Docmd.TransferSpreadsheet. Searched and found the below Sub Routine from long ago that does the Job. Wanted to express my Thanks to LittleSmudge... but...

To simply link tables in Access 2007: Click External Data, then Access Icon, then Select the "Link to Data..." radio button, Browse out to your "brx_data.accdb" file and click OK, you will then select the tables desired. No need to "unlink" them ever. No need to run any of the code you have...

I usually create my shortcuts with a path to the Office files also... this also helps with using multiple versions of Access. Target would be something like this: "C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Data\MyDatabase.mdb" And Start In would be: C:\Program Files\Microsoft...

Might be a silly question.... But are the additional fields you want to see shown on the form? Once you have bound the form to a table or query, in design view, simply drag the desired fields from the fields list that you which to see on the screen. Once the recordset or Bookmark is moved it...

Maybe instead of using the me.txtino try directly referencing the orginal form name directly Forms!OriginalFormName!txtino Hope this helps. Thanks, John

I've had this happen many times, except it was using Breakpoints... very annoying. I believe what has worked for me is to go to the line below your code where it stops and completely retype the line (retype, not copy and paste the original line), then delete the line where it stops (or comment...

Access 2007 Runtime is free, also runs the older databases/mde's.... may want to try it. http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en Runtime is primarily used for the PC's that do not have Access... it will run your MDB or MDE...

Waiting months for this. Have not installed it yet... just spreading the word. Click here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en or here...

I've had this happen many times... very annoying. I believe what has worked for me is to go to the line below your code where it stops and completely retype the line (retype, not copy and paste the original line), then delete the line where it stops (or comment it out). Hope this helps...

Possibly due to VBA being disabled by default, when you first open the database near the top middle of screen you will see an Options button, try clicking on it and enabling VBA. If it doesn't let you click the Options button because your form is open, close your form and then click the Options...

You could also test it on your production machine. Make a copy of your database, rename it extension to .accdr so would end up something like mydatabasename.accdr Then launch the file like normal, it will launch in Runtime Mode... this might tell you if the issues you are having are with the...

So far just experimenting with the split forms... this work is normally done is Excel... about 3 thousand names, going to convert it to Access eventually, but want to keep it as Excel like as possible that they are used to... So far just straight editing of the database table, no queries or...

Trying to use VBA to make the datasheet portion active. After clicking a "letter".. say Z on the Split form, VBA runs to find the first record with Z starting as their last name of the Employee... anyway... it finds the first record OK.. but the split form is active... trying to make the...

Don't know if this helps or not.... I have a PC with an always running Access Program... Issues it had were similiar to yours or bloated to point of no return. What I did to ensure that it would run the next day is: Put Code on a timer to Exit the MS Access program at a certain time (really...

Think I responded on this too soon. Last paragraph of the blog indicates a problem still: ****************************** # Zac Woodall said on August 29, 2007 12:41 PM: Rex: see my previous comment in this post. We're aware of the PDF issue. It looks like there is a bug that our testing...

Supposedly it can now. Link to Access blog: http://blogs.msdn.com/access/archive/2007/08/23/pdf-xps-now-supported-in-access-runtime.aspx Did you get it to work? I haven't tried it yet, but will be in the next few weeks. Thanks, John

You can also do an online test drive of all the 2007 Office Programs... currently looking at the Access 2007 now, it gives a pretty good idea of what it is like. I haven't downloaded the trial yet, just wanted to get a feel of the new menus etc... the online version accomplishes this. Search...

Hey Jerry, What about using a "fake" where clause with an actual Fieldname but the other equation can never be found. Where [fieldname] = 'can never be found' Appears that Top 1 beat it... not that I have time to go to lunch between the two while waiting. Thanks, John

Thanks again Ace, I like the "top" method... will change to that.. easier then rewriting the already existing code to SQL (or creating the appendQry). The Top 1 logically seems that it would be quicker than analyzing my table for my "fake" WHERE clause. Learned something new today. Have a...

Thanks Ace... I believe the Append Query/SQL is the answer... just seemed a waste to create a recordset just to add 1 record. (although the recordset way appears fast enough, was just curious if there was a more optimal way). I will change it over. Thanks again. John