Search results for query: *

Just updated to Access2013 from Access2010. The FollowHyperlink function doesn't seem to work anymore. No error messages... code just freezes and I have to use Task Manager to get out. I couldn't fix it so dropped back to an API call with PtrSafe (which works). Was wondering if a cause or fix...

I had same issue kiwieur had. When I added "Microsoft Outlook 14.0 Object Library" problem went away but we are all on Outlook 2010 (ver 14). Yes, it does defeat the purpose of having 'late bindings'. Without that reference the "To:" email line is blank and the undeliverable error is as...

Try adding Microsoft Outlook 14.0 Object Library ???

On a form in Access 2010 I have a hyperlink field. I want to select and link to a file located in only one folder on our shared drive. When I right-click and select "Edit Hyperlink", each time I must click several times to navigate to the folder containing the files in order to select one. Is...

Tbl1 is one of several imported tables from various existing databases that are converted and imported daily into an Access database on a large network server. I link to it. Tbl1 has no primary keys nor indexed fields. So when I do search on it I can get duplicate records. What I'll probably...

I have two tables in my Access database. The first is a table (tbl1) imported daily from a large database. I want the ability to lookup records from it, choose the applicable record and populate fields into a new record in the second table (tbl2). Specifically, let's say I need to manage a...

Thanks guys, but the example I used was for trying to explain my situation simply. I'd like passing the form's filter to the chosen report to be a given. (The reports use the same table that the form uses.) That way I'm using Access's "Filter By Form" capability to generate filter criteria...

Does not work. I'll try to simplify... Let's say I have a form, "frmOrders", for entry into table "tblOrders". Form "frmOrders" has a cbo field for "tblOrders.CustID" which allows me to choose Customer Name from dropdown list with lookup to "tblCustomer". Table "tblCustomer" has two fields...

I have a form that the Users filter on by using "Filter By Form". On the form are command buttons to open reports using the "Filter By Form" filter. Simple code is: DoCmd.OpenReport "<Report>", , , Me.Filter However, there are cbo's on the form with lookups that mess this up. Are there any...

I've developed a few aps for a large organization. Much data and back end resides on the network. In my code and tables are links/pointers to files on the network. However, often the network guys change the shared drive structure. For example from...

That's currently how I have the form set up, but not what I'm looking to do Zameer, that's why the post. I guess the answer is "You can't group in any way in forms". Another interesting thing is that in Forms "acNormal" view it appears that Can Grow even when set to "Yes" still does not allow...

I have the filter already created. I prefer to keep the filter on the same object that I have the data. It's cleaner and a bit sexier. Unless someone has an answer I'll keep the field I want to group on with the same line/record as the other data and sort on it. It just looks very redundant...

Is it possible to group in a form? As an example, look at Tek-Tips FAQ page: http://www.tek-tips.com/faq.cfm?pid=702 It's records (the 'FAQs') are grouped by 'FAQ Category' (in the light blue band). All 'FAQs', all 'Categories' are shown. I wish to create a form to do something very similar...

What do all consider the best Access Reference book(s) for application development (including VBA coding)?

I have a split database. I created an MDE from the front end. Thirteen users have a shortcut to the MDE. All thirteen have an identical DYMO label printer with an identical name. However, when 7 users print a label, it works great and prints it as a ship label, what I have it set to (I set...

If I run SQL in a VBA pushbutton from a form to Update, Ammend and/or Delete Records to tables from a pushbutton form, I get dialog boxes I don't want. I want (with one click), my form data put amended to, updating or deleting appropriate records without having to respond to each of those...

I have incorporated all four recommendations you have sent and have learned something from each of them. Thank you very much! Here's the updated code (updates bolded): DoCmd.Hourglass True NumberOfWaits = 18 i = 0 ReturnValue = SysCmd(acSysCmdInitMeter, "Cutting Wire"...

Clone a form's recordset, go to and manipulate a specific row in the clone then make the form display the manipulated row.

You can have only one current row in an open recordset. RecordsetClone allows you to point a separate object variable at the original rows to give you two current rows from the same recordset. This is faster than re-executing a query to produce a second recordset, for example.

I have a pushbutton that sends data to the serial port. The problem is that the code takes 10-20 seconds to run depending on which PC it is run on. This causes the user to think it's not working and press the pushbutton several more times, which adds to the problem, often causing the PC to...