Recent content by kidzmom3

:( Sorry, I tried what you posted and it still doesn't work. I've even done some searches on various other forums too, but nothing. Thanks for trying! If you come up with anything else to try let me know!!

: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...

Thanks PBALDY the # signs were the problem!!! It always iseems to be one errant character that causes problems.

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...

Stupid is as stupid does!! I got the function called in the expression -- after I refilled my coffee cup!!!! Thanks for the code help. By the way InStrRev is not in A2000, I'll have to check that out in A2002.

This looks like it would work, but how do I tie it into the expression builder in an updte table query?

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...

Correct! I do not know the pix reference is broken until the detail section of the report formats, and have tried setting it to a blank image, but it just hasn't come together. For now, I've created a bmp file that states 'missing pix' and saved it to the MSOffice/Office folder where Access...

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!!!!

Sorry, but could you explain your last response a little further.

The answer is . . . . for future reference. In the File Name area of the TransferText action in the macro, use this. =DLookUp("[NetworkPath]","tblDefault","[Key]=1")+"file name.txt" where [NetworkPath]=\\NTSERVER\My Files\ NOTE: Be sure to have the users put the back slash at the end of the...