Search results

Hello all, I've been looking everywhere to find a better way of finding duplicates in a table and then recording and adding another value in that record together. Let me try to explain better. example: I have a table that has 2 columns "Name", "DOB". I would like to find all duplicate "DOB"...

I'm not quite sure where to post this question so I'm trying here because it's always been a great resource. I'm starting to get into Regular Expressions programming in Access. I've built a regular expression that searches for variations of PO BOX and RR but it only ever finds the first one...

I've figured it out. Access 2007 has issues running DoCmd.SetWarnings commands. For some reason it works sometimes but not others. I just used db.excuite instead it correctes everything. Thanks for you help.

I've tryed that as well and still have the same issue.

Hello all, I'm having issues with suppressing warnings. As you can see from the quoted code below i am using DoCmd.SetWarnings (0) to supress them but I'm still getting the insert into warnings popping up instead of doing them silently or suppressed. Does anyone have any idea why this would be...

I figured it out. I uninstalled and reinstalled MSPaint from the Add/Remove windows components section and it worked.

Hello All, I have some Bitmaps in a table but whenever I try to open or edit them I get an OLE Server error stating that I need to reinstall it. I'm running Access 2007 on XP. I've looked on the internet but I can't find a resolution. I've tried "Regsvr32'ing" comdlg32.ocx and Triedit.dll and...

Thank you. format([value],"currency") worked perfectly.

Hello all, I have a text box that has an iif statement in it and a referenct to a numerical value that is suppose to be a currency. The table that is providing the source for the report show the value as $x,xxx.xx and if a create a text box with just it in the report it shows as $x,xxx.xx...

That's good information but unfortunately I think I need a full walkthrough or a tut.

Hello all, I know vba and I know mainframe. What I would like to know is how to connect to a DB2 table on mainframe and pull the data and put it into a access table. I don't know ODBC really but it looks like it's what I'm going to need to use. If anyone has a tut or can walk me through...

I figured it out. It was a corrupt tsnnames.ora file.

Hello all, I'm having an issue with using an ODBC connection with a pass-through query in access 2007. I have Oracle 9i installed and am on Windows 7 32 bit. This only seems to be effecting Windows 7 users and not XP users. The error in the SQL Log is this.  CLDemoFE...

Thank you. That worked perfectly. As soon as I saw it was said to myself "Self ... Your stupid." :)

Ok. This is going to be a stupid question but its really earking me that I can't figure it out right now. :banghead: I have two tables. TableA and TableB They both have the same columns. I need a query that will look at the diferences between TableA.Column1 and TableB.Column1 and copy whatever...

I've made the date column so its mm/dd/yyy. The text string from the field should be sort able on multiple months. ie. if the user chooses jan, feb and march the text box populates 01 02 03. I would like to be able to find all 01, 02 and 03 months and have just them display with the proper...

Is there a way of programming the text field so it will provide the variables with ‘or’ in-between them and not in just one long text string?

It's the way the data is imported and because the BE is linked to a bounch of other databases I can change it without reworking every other database.

Ok this should be easy but I’m going a little crazy because I can’t seem to figure it out and I’ve been looking everywhere for a working answer. I have a table that has a date field set to text. I use the Mid function and get just the month in a query. I have a textbox on a form that when the...

That would be it. Thank you.