Search results

Since I have already created the forum with a problem I'm only trying to see names, rather than numbers in, in my export. The damage is already done. I'm only trying to recover my 2500 records. The only obtain I have now is to add a column need to the problem and copy the problem column into...

I added a ListBox to my form using the ListBox Wizard. I am not sure where I went wrong but this is what I am getting. Instead of getting the Values I put in, I am getting the Number or ID that identifies them. For example I have Camera, Graphic and Time but I am getting 1, 2, and 3. How do...

I am using Access 2010 with XP Pro. I am using the following code in my form: Private Sub Seal_Change() If Len(Seal.Text) = 6 Then SC.SetFocus End Sub It works great. I tried to use the same code for my next Control (SC), Private Sub SC_Change() If Len(SC.Text) = 6 Then...

That worked great for my first field, but not my second field. The field is a text field and it 6 characters. One of those characters is a "-". The format of the field is __-___. When I try to use the same code in the second field I get the following error: Run-Time error '2110': Microsoft...

>>John Big Booty << I think your right. I was just testing the waters to night to see what direction I wanted to go. Bob

Sorry guys I thought I was the only one up at this late hours. I decided to make it more clear on what I was doing and did a edit on my topic. Bob

My Table has the following fields: Example: Field A = aaabbb Field B = aa-aaa Field C = aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa When I fill the fields I want them to advance to the next field if they have the maximum characters, 6 char in Field A & 5 Char in Field B. I have been able to auto enter...

>>Galaxiom<< Been a few years since you reached out to help. I save my help topics as you can see. Wanted to thank you for the past help. With out the help from people like yourself and the use of a good forum I mostly likely would be on page 10 of the manual. Thanks again. Bob

It seems that Like is the same as contain. I know id I do a query that is as following: Field: PredominateUse Table: 2010Master Like "*Single*" I will get every record that contains the word "Single" as long as it appears in the Field: PredominateUse. But what if I wanted to match any word in...

>>SmallTime & missinglinq<< Thanks loads. It works better than I could hope for. Bob

>>Galaxiom - It works exactly like any other function in VBA<< Thanks. A good piece of info. Probably as common to use as the day after Saturday would be Sunday but new to me. Bob

There is a On Dirty. Found it. Thanks Bob

On Dirty? I have Click - DBL Click - On Mouse Down - On Mouse Up - On Mouse Move - On Paint. I'm using Access 2007. Is "On Dirty" like back in the day when a Newbe would call DOS Dous (HA). Bob

In my forum I have a field "Town" that I would like to stand out when the value is "1". There is only two possibilities, 1 or 2. Bob

We have a field that should get the current date only if record is changed. The date field is called "change". We tried the following in Field Properties - After UpDate. No go. 2010Master![change]=Date() 2010Master![change]=Date() I would think it would be some kind of an event. Bob

We have a field that should get the current date only if record is changed. The date field is called "change". We tried the following in Field Properties - After UpDate. No go. 2010Master![change]=Date() 2010Master![change]=Date() I would think it would be some kind of an event. Bob

That appears to copy the 10 records above the cursor point...am I correct. How would you go about coping the entire table and/or just the structure itself. When you are doing the copy is it copying just the records or the entire database which would include the queries and forms? Bob

In dBase I was able to do the following and end up with a 10 record table called Bob.dbf copy next 10 to bob Is there a way to do this in Access7. Bob

Green as I am! How does a function differ from a query?

I am looking for a phrase based on if a field (NAME) has 4 characters or more. If the field starts with 4 characters or more. I want to take everything up to the first space or the end of the field, whichever comes first, and put that into another field called (SECNAME). Bob