Search results

Hey thanks alot! That worked like a charmed. Now I'll know how to avoid that problem in the future.

Hello there, I have a combobox in a form used to bring up inventory information, by Item Description. Several of the items have apostrophies in thier discriptions. When I use the combobox (using FindFirst), to pull these up, I get an error. I've no doubt that the apostrophe is causing the...

I've been trying to get this code to work, but it just doesn't seem to put the data anywhere. Any attempt I've made to transfer the RecordsToConvert recordset to a table have resulted in a type mismatch error. Also, I tried to parse this in excel using the conversion wizard, with no luck. I...

PeterF, you are my hero! I copied your code into a module and changed my table properties to match accordingly. I run the code and it cycles through, but when it stops, there are no new records anywhere. I thought maybe they'd be in thier own table, but maybe I'm not fully grasping what the...

Well seems like a good start. I've never used the Split() function before. What do you think is the best way of applying it to my situation? I couldn't find an example in the help file, so I'm not sure what to do with it. Thanks! Ben Bolduc

Hello everyone, I understand that this is an unusual and difficult problem. If there is anyway I can clarify something to make it easier please let me know. A push in the right direction is all I can hope for. Thank you so much for your help, I truly appreciate it. :) Ben Bolduc

Hello everyone, I'm trying to import data from our current Database Pro v1.0 DB to an Access DB that I'm creating. Our DBPRO is essentially a flat-file data entry program. It has a "subform" for history events that isn't actually in it's own table, but all concatenated in a single [History]...

This looks great, thanks alot. :) What do I set rs and txtProductInfo to though? :confused:

Duplicates in this table are OK in general. Most of the time, though, it's bound to be a user mistake. This is just a temporary table used to accumulate products on an order. The info is appended to the real table upon confirmation of the order and is then purged for the next one. The...

Hello everyone, I need to run a line of code that checks the "TempPurchase Order Entry" table for duplicate [Product Code]'s. If there are duplicate [Product Code]'s, I'd need a msgbox to come up for user verification. Thanks so much for your help! Ben :)

Wooohoo! Thanks :) Using this, I fixed my problem and also enhanced some of the other feature of the form. Thank again, Ben

Hi Everyone! I'm having problems and am frustrated as usual ;) I'm trying to select a specific row in a listbox in the OnKeyDown event on my form. Basically, while in a subform, I want the enter key to move the focus to the list box, specifically to row After the last selected. Here's an...

Hello, I have a report that I would like to group/sort by [Brand]. The problem I'm facing is that for this report, I need the Brand to be listed in a specific order; niether acending or descending. Is there an easy way to list the order I would like the brands to be displayed in? Thank you so...

Yes, that's correct. I know it seems easy, but I can't get it to work :) Can you help me out? -Ben

Hi everyone, I have a report whose query criteria is set to a series of comboboxes on the form that opens it. I can get the comboboxes to work great together using Iif statements, but the one problem I'm having is with the date. I have two fields on my form that I would like to be able to...

It works! Thank you for the fix guys. I'll try to watch myself using special characters and spaces. I know someday it will come back to haunt me. ;) -Ben

I tried that and the same thing keeps happening. When I tell it to show everything through an expression, it shows nothing. Now if I remove the expression from the criteria it does show everything so i know it's not my data. Does anyone have any other thoughts? Thanks! -Ben

Hello everyone, I'm trying to create a criteria in the query of a report that is based off a text box in a form. It works easily if I just put [Forms]![Prod Sched (BP)]![TheLine#] in the Line# column of my query builder. My problem occurs when I don't want to specify a number and want to...

Hi everyone! I'm having a simple problem with one of my list boxes, or so it seems. All I'm trying to do is make it go to the next record in the list when I hit the PageDown key in a subform. I've tested the On KeyPress event and that's workig fine, I just can't seem to find a...

Hi Jenny, I found that when you need to manipulate information based on a consectutive numbering sequence, autonumbering is NOT the way to go. I only use autonumbers as primary keys when the actual number itself doesn't matter. When I ran into a similar problem for the first time, I created a...