Search results

I like to add the current date to the email text. And better yet to the filename being created. Can anyone advised. Attached is what I have now. Russ

I am trying to a new field based on two other fields: The new field is "AnyTestingNDTor5500", the field's value is "Yes" if either the two individual plan testing parameters are set to "Yes". Below is what I am trying and getting a syntax error. CODE AnyTestingNDTor5500:iif(([Plan Testing]...

I have a field that I need to replace the 4 character in with a dash when the position is null. Sample of input values: ABC GATE HAV ROAD Output values wanted: ABC- GATE HAV- ROAD I have tried this and variations without success: Outputfield: Replace([Inputfield],"","-") Any suggestions...

How would I identify the value (field) in the drop-down of an unbound combo and get it passed to the query behind the report. Attached are a couple of screen shots that show how it is going. Screen shots 1) form in design mode 2) the vba code behind the button to create the report Thanks for...

I need to get the active tab name from the form? TxtQueryVarible = Me.TabCtl14 MsgBox TxtQueryVarible, vbOKOnly, "Confirmation... " This tells the tab i am at is index 0 Thx Russ

This is a vba module that generates emails. I added only 3 lines. # SysCmd acSysCmdInitMeter, "Currently Emailing ", totNumRecs SysCmd acSysCmdUpdateMeter, "Currently Emailing ", intNumRecs SysCmd acSysCmdRemoveMeter # I am getting a Debug message on the SysCmd...

I am using a common function xmail and the cc part is not working does anyone know what i can do to fix it? I get the to part of the email to work but the cc will not work. It is listed as the cc on the to mail, but the email for the cc is not generated. Thx Russ below is code: Option...

Please see the attachment. I do not know how - why - there is this line on the side of the form with and arrow. But I would like to remove it. I could not find out to. Russ

I know my loop is working because the counter is working and I am getting three emails. The problem is the value from the table is staying with row 1. I do not know why the row 2 value is not being loaded into the varible and emailed to me. The value getting loaded into TxtSubject is staying...

There should be a way to run an "auto-marco" as in Excel that does the Compact and Repair that can be put on an XP-Scheduler to run nightly. If anyone has this process working let me know. Thx Russ Russell.Neuman @ LFG.com I will post one if I figure it out.

I had some break points - I cleared them. But everytime I start the DB the code displays and stops in debug mode. :confused: I cannot get the code debug screen from appearing. Any ideas? Attached is what happens. Thx Russ

I posted this in the query area no replys... :( I need my data to fill the sub-form come from one of two possible inputs based on plan-id. I am not clear on how to select the data to fill the sub-form. There is the main form with data from DB-A, then there is a sub-form that needs filled...

I need my data to fill the sub-form come from one of two possible inputs based on plan-id. I am not clear on how to select the data to fill the sub-form. There is the main form with data from DB-A, then there is a sub-form that needs filled with data from DB-B or DB-C, based on the key...

Is there a easy way to do this? I tried Lock but then the users can not add a record. I want them to be able to add but then lock them out of updating a field. Thx Russ

fieldwithOnly1space: Replace([fieldwith2spaces]," "," ") I am trying this but it is not working any good ideas on fine tuning it? Thx Russ

i have zips that 12345- and 12345-1234 The problem is the dash is on the field of the 5 digit zips. So the shortest zip is 6 characters. When putting the data on reports we do not want the dash to show on the 5 digit zips. But do want it do show on the 9 digit zips. I am not sure how to...

I have names in one field and I want it to be initials in a new field. Can someone gave me a push. Field Name = Tom Smith Field Initials = TS I have Name. So, I am thinking it would be: In the query it would be a new field Initials: ???? Some Function or Iff statements... THX...

I am trying for the 1st time to pass Access variables to a Word document. I used this as a starting point http://support.microsoft.com/kb/260410 It seem fairly straight forward. I made a little db with one table - one record - and I am attempting to have it pass the data and open a Word...

I have to pull a few fields from another DB (DB2) on to some screens where i am updating the data pulled for the display of data on a screen. I do it with a query joining the data from the other DB (DB2) with the table from the DB i am updating (DB1), the update process will not work. I...

Is the an way I could default the year on my forms. I tried the attach screen print without success. Thx Russ