Recent content by Brookelyn

Transferdata using a macro Not sure if this helps or not, but I have a program similar with the long fields. I made a macro...it opens the table of which i want to export and then i used the transferdata ability. On the transferdata there is a line that has a specification name. You can push...

Just a quick question about this topic. Isn't coding it this way only a temporary way to write to the rowsource? I read that in one of my reference books and was just curious. :)

Nevermind my last post I got it. Thanks for your help guys! :)

Great that works. Heres the same problem that I had yesterday and I used the same technique here as I did to solve yesterdays problem, but it didn't work. It wants me to enter the parameter value of ftrBrand. ftrBrand should equal the data that is entered into The Inputbox. Can you help me...

The following code gives me a syntax error in the INSERT INTO statement. I can't see the problem with it considering it pretty much looks just like my other sql string. Can anyone else see the problem? I'm sure it's right under my nose and I've just been looking at it too long. When I hit...

Works beautifully. It would have taken me awhile to figure that one out. Thank you so much for your help. You've been great. :D

Okay here's something that might be a problem with that? My id field has - in it. Such as aroma-therapy-foaming-shower-gel could that be a problem? I also tried it on my code(which cannot be duplicated or null) field which is something like MO12345 and it still gave me the error

Now it gives me a datatype mismatch in criteria expression error

According to ejstefl's page posted the recordcount is supposed to be better. so if you want to have it displayed in a msgbox just take aout the Me.txtStaffCount.Value = rst.RecordCount and replace it with msgbox rst.recordcount it works :) Hope that helps

Hi, I'm really new to VBA but obviously that way is doubling the amount of records you have. Have you tried using a DCOUNT()? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acfctDCount_HV05187157.asp Has a complete definition of it. I just tried it on my...

I have checked the names of both fields, but I still get the enter parameter. I am not sure how to post a sample db or even create it. But here's how it's set up. I have a table named Store Data that contains EVERYTHING about a product. I then have a Table called deleted that will only...

Hi Pbaldy, I'm sorry to keep bothering you. I used the code that you gave me, but now when it runs, it wants me to enter in the value of the ID field. I would like it to just automatically accept it from the record that it is on. I looked at the .currentrecord, but i'm not sure how to make...

Hi, Thanks for the advice. I am unsure of what to put in the where condition simply because the data will always be different. Any suggestions? Thank you very much

Hi, I am creating a database in which every time an item gets deleted from the main table, it will be added to a different table. The code example I have at the bottom does ALL the files in that table. How do I get only the current record that I am on to move? I have tried do while, with...