Search results

Ok if i wanted to use the unbound form and command button and loop through the records set. how would i do that. So the question is how do i open a record set in the code and loop through the record set. Thanks

OK, it failed again and highlighted the "If Nz([Cas Reg List], vbNullString) <> vbNullString Then" in the code. The error said that id did not recognize the field. I noticed you stated that the record should be in a form. Currently my data is only in a table and the table is closed. Then i have...

I just mean a regular form. forget i said frontpage.

Hey, I appreciate all of your help, I am trying to put the code below in where [Cas Reg List] is where the existing data remains and I am trying to put the filtered/seperated values in the [ES Purchases][TestCodes1] Table. The command button is Command65 which is on a frontpage type form. I have...

I am sorry I am not the best at the visual basics aspects of access. I originally was thinking that i would put the code in VBA in a query which when ran would add the data to a field or a new record. I dont even know if that is possible, but I guess you are talking about actually making the...

Should the Your Field that you put in the code be in brackets? ie "YourTable(YourField)"

It looks like the only thing that i have to change is the name of the field in the [Brackets]. Right

For the first option cut from your text and pasted below, did you mean to say that this would put the N number in a seperate field seperated by commas? I ask because the second option explains that it will make a seperate record for each n-number also "With that in mind, an Array would come in...

So what do i need to change in this code? Do i need to change anything or just cut and copy into the VB expression.

1) Very good question. There could be a multiple array of letters and digits. For example another cut and paste from my table is below. So the answer to your question is yes. 192TX 3 A C F N N090 N982 O PM TAPII Y R Let me caution you that there are also stand along "N" seperated by spaces...

Hi, I am trying to do something pretty crazy. I have succeeded in excel to a point but I want to do this in access. Hopefully someone can help me. Take a look at the cell of information below and imagine that is a value in a field. The data that I am interested is the N078 and the N420. Each of...

Yeah that worked. Thanks alot. I knew that had to be pretty easy.

Hi, I have a query by form where if I put in the year on the form the query brings back records related to that specific year. This is great and works, but as a default I would like all the data to come back. For example if I do not type any year in the form, all data from the original query...

I dont know how to go about doing it? Do you

Hi, i was wondering if it is possible to change a form type after it has already been created. For example when you go into the form wizard and choose a tabular type form. Open it up and mess with the design, Can you then change the form type to a datasheet or other type. I have always just...

I dont think that is the problem. I am just asking how to do something. My data is not redundant. should i make another sub table/sub form that will open with a command button to enter multiple date for the Text box and link it through a child? Thanks

Hi, I have a form, where for each record there is one particular data point for each combo box in that record except one. One Text box will require multiple data points that i would like to make quantifiable. For example, lets say 100 and 200. I was thinking there would be a way to make...

So you are saying to use a bound text box? thanks

Hi, I have a problem. I currently have a form based on a table where when i put data through a combo box in one [cell], it auto populates an unbound text box [cell2]. I have the autoupdate completed through an after update event and it is working. But the problem is all the records in the form...

I knew it was easy, thanks