Search results for query: *

Hello to all. I am new to VBA but hopefully someone could help me out. How can I store a value for example "LANE1" So that I can this value, on a field for a table, form, report rather than hardcoding it for each. This way, it would be easier to update it in 1 place, and all the objects...

thanks to all. I just added a text box with the code of =count(*) and it accomplished what I needed. I am still new to VBA in access. So much of the code is new to me... I do however need help on another issue. The form is set up to open each time and filter for a new record with no data...

How can I add a counter on a form so as a new record is added, the display counter continues to updated?

Good morning to all. How can I set up an input field on a form to default a number 1 but allow that qty to changed based on a check box with a different qty.... For example I can have 3 check boxes. qty 6 qty 12 qty 24 When the form opens the first record would default to 1. All records...

Is there a maximum number of records or size that is allowed for a table in access? Is there a point where it where no longer accept anymore records? Is there a way to see the current size of a specific table? Thanks in advanced.

where would I turn Echo off at?

I have create a application that runs thru macros. I notice that when this happens the screen slickers off and on. How do I prevent that from happening? Thx,

What would be the easist way to do the following.. I have two files being appeneded together with the fields below. Unique sku# Units file1identifier I want to get the count of unique skus for each file... Total units for each file and then a grand total of unique skus for both files and...

I got it to work. Thanks for your help I really appreciate it. Are there any books you recommend that teach you how to program in access?

I can't seem to get this to work.

I have never written VBA code. Where would I put this. Sorry still learning.

No essentially I import an excel file that contains the following fields sku SumOfUnits Cat StyleDescription This gets appened to a table that contains those fields plus an anutonumber field called "recnum" Currently it is an autonumber field and if the database has been compacted the first...

How can I create a query / or some type of counter that will populate a field based on its order imported. Essentially, it would be like an autonumber, but I want to be able to reset the number to 1 when needed, and within access I only know of doing this by compacting the database. Any help...

I really don't know. I import a file from Excel which has a unique auto number. I then need to break out the file into 3 parts. WIth eacn new file starting the auto number at 0 again.... don't know that makes sense.

Is there a line of code that can be ran thru a macro, to reset my autonumber field back to 1? I know I can compact the database using the menu options but I wanted to automate this to run after a specific macro so a user does not have to do this manually. Thanks in advanced.

Thank you very much it works!! I must have pasted the code wrong yesterday...

I get an error that says... It can't find input table or query tbla

sure.... My table name = zzz_FonABC2 my unique Field = rec# Field I am trying to do a running total on is = %Activity If possible, I would like to populate the running total into a field called = Cum Activity Let me know if this helps... Sorry am still learning.

I am confused on the part of... FROM tblA A WHERE A.AutoNum<=tblA.AutoNum what would be the tblA?? and then it starts again with....A where

what if my autonumer field is actually a number? do I just replace autonumber with number?