Search results

:confused: I can't seem to get my combobox to autoexpand. Auto expand property is set to yes. I've even deleted it and reconfigured the control. I've changed options, keyboard from start of field, end of field, etc. -- still nothing. Does anyone know if format and input properties in the...

;) Hope this helps some of you with that quantity and quantity on hand issue. I'm using ACC2000 and I've been reading a lot of posts out here on my quest for a solution without writing the totals to my tables and finally came up with a very simple one using bits a pieces from various posts. My...

:mad: I have a report that I added to the Design Master of a replica. The report previews based on criteria entered into a form/query. If I preview the report from report design and type in my criteria, it works fine, but when I try to preview it form a command button on the form after...

This one has me stumped at the moment! I have a report in ACC2000 that is grouped by customer, then lists all that customer's inventory, then the next, etc. etc. It works fine except that my customers info does not print at the top of each page -- it prints once until the customer changes then...

This is revisiting existing postings. I have a form to add new records and I need one field to increment by 1 based on the employee ID chosen in a dialog box. For each employee ID there can be unlimited Items, but each employee's items must start at 1 and increment from there. I set a...

I've been trying to develop an expression that will give me just my file name at the end of a path, i.e. C:\MyDocuments\MyPictures\ERFG4567.jpg Where I just want to get the ERG4567.jpg. I have 2 variables with trying to work this out. One is I have no idea what the path will be, so there...

I have a report with images (using the path name method). I have it error trapped, if there's a broken reference to an image. It works with one exception, the image frame for the record with the broken image displays the image from the previous displayed record. I've gotten around this with VB...

Does anyone know if snapshot files have a size limit? I have a lot of photos in the report, and it doesn't seem to want to work past 50mb. Also, does anyone have a recommended size that JPEB files should stay within to work well with the snapshot viewer? As always thanks for the input!!!!

Is there any place to go and find out what library replaces what when going to the XP(2002) version of Access? There used to be an Office Compatible 1.0 Type Libary (msoc.dll) in AC97/AC2000, but has vanished (at least with that name) in XP. As always thanks for your responses.:p

I have a macro in which I'm using TransferText action to import a tab delimited file. It works great, but I need the File Name to point to a default UNC path that the user(s) set up and store in a table of default settings, i.e. tblDefault, field=NetworkPath. Any ideas how to get the file name...

I know we've visited this topic before, but I still can't get it working properly. I have an image path I'm storing in my table with a link to an image (object) control on my form. Works great, except when I go to a new record. The image control is displaying the previous records image until...

I have a control on a form that needs to increment to the next available number on a new record. I have code in the event GotFocus and this works, except only when I click on the control or shift+tab back to it. I've checked my tab order (the control is first) and when a new record is started...

I have a combo box (CustID) w/3 columns (CustID, Customer, Phone, col. 1 is bound. I want col.3 to fill in the bound txtPhone box on my form after choosing the CustID. Here's my present code which always returns a null value: Private Sub CustID_AfterUpdate() Me!txtPhone =...

I have a date field in which some records are blank. I want to query those blank records, but I keep getting a "data type mismatch in criteria". I have tried IsNull, "", ##. Nothing is working! HELP! [This message has been edited by kidzmom3 (edited 01-30-2002).]