Search results for query: *

Hi All, We have been receiving data for mailing lists in Excel spreadsheets that have a line feed or carriage returns (chr 10 or 13, I believe) When imported into Access the character appears as a square box like many unprintable or foreign characters. I need to alert operators to the presence...

Hi All, I need to produce professional looking merged letters that are driven by and display data from tables. Some of this is simply conditional formatting but the more complex part is displaying certain records in a one-to-many table that are flagged with a descriptive paragraph. Access...

Hi All, I need to produce professional looking merged letters that are driven by and display SQL Server data. Some of this is simply conditional formatting but the more complex part is displaying certain records in a one-to-many table that are flagged with a descriptive paragraph. Access...

Hi All, I want to add a field to an Access 03 table that records the user logon that added a record. I thought I had used GetUser in the past but neither the help or knowledge base had that phrase or others I tried. Isn't there an easy way to trap the user logon? Thanks, alr...

Hi All, I added a new feature to a production application (Access 03). Everything works as expected except, the first time you use it, the code window opens to the "If" staement below. If I hit F5, it runs perfectly. All break points have been cleared yet this continues to happen intermitently...

Hi All, I have tried: DCount("[searchLname]", "prepsearch", "IsNull([SearchLname])") DCount("[searchLname]", "prepsearch", "[SearchLname]=null") DCount("[searchLname]", "prepsearch", "Len([SearchLname]) < 1") ...as well as several different concatenations. I could not find specific...

Hi All, As long as I can remember, GoTo was considered bad coding and was to be avoided. I have used them whenever the circumstances seemed to call for it with no known problems. When stepping through a recordset, once a record has all of the processing needed I may be skipping 20 to 50 lines...

Hi All, I want to set the default value of a table field to the contents of a form control. I keep getting an error that the form control cannot be found. Is this possible or do I need another way to populate the field. Thanks, alr _____________________________________ There is no rule more...

Hi All, I am trying to set the default value for a table field based on a form field and an auto number field to create a unique ID across all of our work. When I enter the expression: =Right([Form]![frmWkDt]![txtReqNo],10) & [idwo] I get the error message: "Could not fine field...

Hi All, I am trying to write a city, state, zip splitter. I have a lot of the logic worked out once the field is split but sometimes that are many spaces internally, plus I need to look for commas as separaters also. The code could repeatedly replace double spaces with single spaces or look at...

Hi All, I have a complex text reader that uses the File System Object (Access03). There is a custom error tracking system that pinpoints errors with messages that help track down errors. An error came up that stopped execution with no messages. By tracking down the line of code that caused the...

Hi All, I have an application that does some extensive calculations on open that can take up to 20 minutes for a 2 gig file. Rather than opening the main form, I have created a modular, popup that gives users the choice of a normal opening or to supress the calculations. Things seem to be...

Hi All I have a form (Access 03) that calculates some statistics in the OnOpen event that can take a long time for large files. I would like to give users the choice of not running these calculations. If the file is over 1 meg a modal popup form with two buttons opens and sets a variable based...

Hi All, I am writing code to split the city, state, and zip line of addresses into different fields. (Access 03) I got stuck on the following line to identify zip codes that are 5 digits and a space followed by 4 digits. (strZp is text to the right of space, valid US state code, and space) If...

Hi All, I am trying to gather some stats on the current work being done and have the following statement to get the lowest cliam7 number in the table WkDt. When the assignment statement runs, it errors out with a dialogue box that says,"Overflow". Dim StNo As integer StNo = DMin("claim7"...

Hi All, When I step through the 3 lines of code below the first 2 run fine and make the correct assignment. The third line has a "type mismatch" error. (Third just combines criteria) rsGtoHistory!gtosread = DCount("gtoimportid", "tblgtoimports", ("[gtodateimported] >= #" & dtRunBegin & "#"))...

Hi All, I am creating a DCount statement with rather complex criteria. (Access03) The simple version below works if I use a hard coded date but I am having trouble using the VBA variable dtDateBegin. DCount("importid", "tblimports", ("dateimported >= #dtDateBegin# ")) DCount("importid"...

Happy Friday All, Using Access 03 with Win XP Pro: I have several mdbs that each perform a function. Now that these work I would like to have a master mdb that starts one of these mdbs and when it is finished starts the next one until they have all run. I presume that I will have a form where...

Hi All, I run some very lengthy reports (Mostly queries) and long operations cycling through upwards of 1 million records. The Task Manager Cpu stat is sometimes pinned at 100%. At other times it stays in a range of 5%-20% or somewhere inbetween, even for the same task on different days. Is...

Hi All, I'm sure I did this somewhere in the past but the syntax escapes me. rst!arFields(intFlds) where: rst = recordset arFields = array with field names intFlds = looping integer I tried [] "" & etc. and cannot seem to get the field name recognized. This must be possible right! Any...