Search results for query: *

Thanks Skip. This was the way the box was presented to me. If I had the freedom to redesign the register, that would completely alleviate my problem. I only mentioned the aggregates so as not to get an overly simplistic answer. That still leaves my original dilemma. The Balance column...

...1000.00 21450 12/1/05 20.00 980.00 980.00 ** The 2nd $980.00 should be under balance, but screen doesn't display it that way. I would want to post my payroll entry just under the check #21450 on the same...

Trevil, Just now getting back to this project. I think we are on the same wave length. I only want to present tabs for the particular address types that exist. The address name in the table is not limited to certain types, so I'm changing the caption based on the field value. One thing that...

Thanks Trevil. It was a combination of the sql statement that I had built not being assigned to the recordsource of the subform(duh!) and refreshing the form. The subform would display but with the same client, as they are the first client in the results of the underlying recordsource. Using...

I am working on designing a db that will manage our client maintenance and processing. It's slightly broader than that. There has been a much needed push to centralize info in our company. Except for being available for viewing on our website, it's not being utilized. Needed info is located in...

Got this working well sort of. I was able to link tables with ADO. I ended up parsing the UDL which contained the connection string. The connection string I have access to, details the dsn and such. Basically I ended up creating dsn-less connections with ado. No ado connection is really...

...OLEDB:Create Link") = True Tbl.Properties("Jet OLEDB:Link Datasource") = cn Tbl.Properties("Jet OLEDB:Remote Table Name") = sTblx ********* works up til here and then i get this error message: 2147467259 - 80004005 Not a valid file name. ' Append the table to the Tables...

No luck so far. I will keep trying. :)

Thanks cmmrfrds. I have seen this solution all over the place. If I am not going to be able use the UDL which has the connection string, I will just use the DSN-less DAO function that's already working. One thing that I failed to mention is that I have opened a recordset on a form that is...

...New ADOX.Table Tbl.Name = sTbl Set Tbl.ParentCatalog = Cat 'not renaming table as I am trying to link to target table 'rename it 'Tbl.Name = sTbl '****** 'Appears to work until here 'Then I get an error message 3265 - not in collection 'Unable to link table, so it's not in collection 'Do I...

...Cat.ActiveConnection = cn 'get table reference Set Tbl = New ADOX.Table Tbl.Name = sTbl Set Tbl.ParentCatalog = Cat 'rename it 'Tbl.Name = sTbl '****** 'Appears to work until here 'Then I get an error message 3265 - not in collection 'Set the properties to create the link...

figured it out. placement in reports is everything. my code needed to be in the groupheader format section instead of report open. it is so frustrating to grasp the stuff that should be complicated and spend 4 hrs trying to figure out something so trivial. the devil is in the details. thanks :)

paramit81 I am assuming that your field is holding a number or string that is a number. if it is a date you can use the datepart function =Datepart("mmmm",[fieldname]) replace mmmm w/ m or mm for number or mmm for month abbreviation thanks :)

this code will be used instead of your monthname function in the code module for the report. i usually put my statements in the section where my info is: group header, page footer, detail, etc... in this example monthnum would equal the name of field that has value you want to test. you...

it sounds like you got it working but instead of having it equal the month name, which you have to assign, you assigned it the value of your field or the number instead. :)

ElseIf monthnum = 2 then lblMonth.caption = "February" You can assign values to the text box as well. :)

Correction to post above: If the global variable is empty I assign the report variable the calculated date. My goal is to have the invoice show the dates in the report if it is open from the icon instead of thru the report. A snp copy of the invoice would be in the clients subdirectory, but I...

I have never used that particular function, but why not assign your labels values based on the number in the field: EX: assuming text If monthnum = "1" then lblMonth.caption = "January" ElseIf monthnum - "2" then lblMonth.caption = "January" elseIf etc... End if assuming number If monthnum = 1...

Hey Duane, I'm glad to hear from you. I read your stuff all over the place and am quite impressed with your solutions. As you may have guessed, the "programmer" in my handle was a typo and I'm not sure how to have it corrected. I'm self taught in Access, VBA and SQL. Owing much to the "real"...

Thanks traingamer, the problem was in the sum of charges field. I was using IIf statements as the control source for the legal fee and the sales tax. I did use the Nz function for late fees. I'm not sure why, but it is now working. I removed the IIf statements and am assigning the values in...