Search results

answer I have a 6 byte text field that I want to increment by 1 every time a record is added and padded with zeroes to fill all 6 bytes. thanks for your help

? what does younumberhere stand for? Actually key the number? that would not work I want a nuber to be added sequentially for each record with padded zeroes based on lengh

? Is this to be placed in a query?

I have a text field as 6 bytes but my vendor requires this field to be as shown in the example (sequential). Is their an easy to do this in the table? 000001 000002 000010 000011 thanks

currently when the form loads the find/replace box pops-up and is set to look in the name field on the form. 1. When the user enters the name in the box and then finds the record I want the find box to close automatically. 2. The user tends to click in different fields when browsing the...

more help please I have not used Access in 3 years so I will need more info. I can create a prompt qry that asks the user to key in the value. THey want more than this. The user would like to see the values and just click on the ones that want. thanks

I have a form which opens in datasheet view with over 3k rows. I have a field named type which lists each member's type code. Example 500 customers can be coded as better, 200 as good etc. When the user opens the form, I want a prompt to allow the user to select these values from a list which...

thanks I have not used access in a year and forget many things. Thanks!!!!

I have a column with variable length data such as: Tp190 25 09 ZW5623 23 01 ZX115 11 23 12 456 09 I want to strip off the last two bytes of each record in a quick manner. Thanks!!!!!

Does anyone know of any free/cheap software that can take a delimited or fixed file as an input and the output as fixed or delimited especially allow for inserting filler or hardcoding data. I have used MA Accss export specs in the past but the inserting of filler or hardcoding is not quick and...

What is not clear in this post? I am trying to transpose data based on the example outlined in the post.

I have two columns named group_id and customer #. Example of data below. group_id and customer # 1 890 1 990 1 567 2 111 2 132 Here is what I want to do using Access or Excel. Group...

I need a formula in a main form that uses two form field names. One from the main form and one from the subform. I does not seem to work as I keep getting #Name? Can Access handle this? thanks, help :confused:

thanks All of your suggestions worked very good!

help can you pull use name and date time at the same time?

I am using Access as an interface with a SQL database. Currently, when a user changes a particuler field I use an event to update the date of last change on the form. I would like to add user name also. I have not been able to figure this out. HELP! thanks,

I have a form where data entry is performed. This information is sent via e-mail as an Excel attachment many times in one day. I am looking for a way to have any changes since the last e-mail to be highlighted or flagged in the attachment. Therefore, users can only concentrate on what has...

any ideas?? I cannot seem to figure it out?

I have order #, customer, SKU, and # of SKU's in a file. I am trying to find any cross sell opportunites. In other words, When product X is ordered, 60% of the time product Y is also in the order. Help!! I do not know much VB.

thanks I guess I am not explaining this correctly. I will try to figure it out.