Search results

I have a report with a subreport for detail. The report has a couple customers who end up having what looks like identical subreports showing up in the detail when I run the report. I have found one case where the subreport is returning slightly different data. I only have one subreport in...

I have a function that is run as part of a query for scrubbing addresses in order to eliminate duplicates. To help find dups I get rid of things like ST and RD because they are not always included in the address. I thought it was working but noticed that in some cases, and I can't figure out...

I need to standardize some address fields. I am having a problem with splitting number and letters in a address field. For example: 2400N Main Street trying to switch to 2400 N Main Street I can't figure out how to update this in VBA. I tried a update query and can get the criteria to...

I have two identical tables with one being created by coping the structure of the other. Table A is my primary table. Table B is my new data imported table. I created a Update query with a dlookup to update Table A's address field from Table B. All records fail to append due to type...

I am trying to compare IP numbers from a log table to a table of blocked IP addresses. Since IP Address don't lend themselves to comparisons I converted the IP address into a number like this: (Octet1*256*256*256) + (Octet2*256*256) + (Octet3*256) + Octet4 I can then compare an IP to a block...

I imported a log file into access and am trying to parse out the data to a new table. I have been using the Instr and Mid function in a Query just fine. However, I could not get the second or third comma seperated field to get pulled so I created a function to do the job for me. The problem...

I am trying to export a query to a fixed length text file. I setup the specs for the fields and tested the export fine. However, when I made some adjustments to the formating it fails. So I went throught and format field by field testing the export each time and this is a problem I found...

I have two identical formulas to compare some dollar values. I need to compare two numbers in two different tables, [pymt_amt] and [SPrinciple]. The first formula returns the Value if two fields equal each other. The second returns a value if they don’t. The problem is the second formula is...

I have a table made up of imported data with a couple currency fields. I am only having problems with one field. It will show up in a query but if I do a sum on the field it returns zero. I checked the type and it imports as a decimal. One of the other currency fields I imported is formated...

I get a data type mismatch when I run the following in a query: Int: DLookUp("[amttxn]","fhlb_activity","[effectiveDate] = " & [effectiveDate] & " and [loan_no] = " & [loan_no]) It has to be something simple but I can't figure it out. Any help?

I am trying to import a windows 2000 event log. I used dumpel.exe to dump the event log into a comma delimited file. Everything looks fine. When I import into Access it always gives me an error on my time field. Eveything else imports fine. I even created a table first and formated the time...

I have a somewhat complex query that locks up and utilizes 60% of the processing power of a dual processor server. I have to kill the process to stop it. I got it down to the following causing the problem. Working Query Portion: EffectiveDate: DLookUp("[txn_date]","lns2e","[loan_no] =...

I have a update macro that needs to run every 3rd Thursday of the Month. Is there a way to calculate what the date would be on that day? Or is there another solution (other then manual entry and a handy calendar)?

I have an unbound calculated text box for each record on the report. I am trying to do a count on this calculated field but it always gives a pop up what that field value is. I few variations I have tried are =count(txtNew) , =count([txtNew]) and =count(iif([txtNew] = 1, 1, 0)) and I...

I am trying to add a new record to a table with the following code. I keep getting the following error. Run time error 3001 Invalid Argument All the other posts I found look just like mine so I can't figure out why it's not working. Since the code works with the currentdb I didn't think...

I am trying to export a table to a .csv format with no text qualifiers. I created a spec file with comma delimited and no text qulifier but I still get "" around all my data fields. The program that needs the data can't import with "" in the data fields. Here is a copy of my code but I don't...

I have the following procedure that I am having problems with. I compared it to another procedure that is almost identical and found that tmpAcct# = GSB is giving me trouble. I had GSB as “GSB” since it is text going into a text field using the dim default of variable. If I have the quotes in...

I have a database setup to run a bunch of reports and print them at a certain time using scheduler. Works great. We wanted to switch to emailing the reports which also worked fine using a sendobject macro. The problem is that unless I have outlook (running with an exchange server in this...

I have a one to many relationship between a customers table and a servers table. I have a customer form with a server subform. I added a oncurrent event procedure to the servers subform. It seems for some reason the oncurrent code I have or any on current code causes a problem when I delete...

I have make two copies of a database at the end of every month. One gets archived and the other goes into an end of month folder which gets copied over every month. I run a bunch of reports at the end of everymonth. I need to put the "as of" date, meaning the last day of that month on the...