Recent content by kplatt
-
K
Look up and replace data from one field into an expression field
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 -
K
Look up and replace data from one field into an expression field
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... -
K
Look up and replace data from one field into an expression field
I just mean a regular form. forget i said frontpage. -
K
Look up and replace data from one field into an expression field
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... -
K
Look up and replace data from one field into an expression field
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... -
K
Look up and replace data from one field into an expression field
Should the Your Field that you put in the code be in brackets? ie "YourTable(YourField)" -
K
Look up and replace data from one field into an expression field
It looks like the only thing that i have to change is the name of the field in the [Brackets]. Right -
K
Look up and replace data from one field into an expression field
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... -
K
Look up and replace data from one field into an expression field
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. -
K
Look up and replace data from one field into an expression field
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... -
K
Look up and replace data from one field into an expression field
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... -
K
query By Form but Bring back everything as default
Yeah that worked. Thanks alot. I knew that had to be pretty easy. -
K
query By Form but Bring back everything as default
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... -
K
Form Type (collumular, datasheet, tabular)
I dont know how to go about doing it? Do you -
K
Form Type (collumular, datasheet, tabular)
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...