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...

I have a process that is automating our various payroll entries. Once this has been done, I am wanting to automatically update our checkbook register that is in excel. The excel spreadsheet already exists, i know how to open an existing workbook and find the appropriate month's worksheet...

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...

A little further along, but now I've got a different error message. Public Function LinkTables(sClt, sConn, sTblx, sTbl) Dim cn As ADODB.Connection Dim Cat As ADOX.Catalog Dim Tbl As ADOX.Table 'create new connection Set cn = CreateObject("ADODB.Connection") sConn = "File...

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...

I posted this Access Tables and Relationships. Thought it might be better suited here. Sorry for the cross posting. Working in Access 2000 First attempt at using ADO instead of DAO. Currently I use dsn-less connections to create table links in code. I'd like to replicate that with ADO if...

First attempt at using ADO instead of DAO. Currently I use dsn-less connections to create table links in code. I'd like to replicate that with ADO if possible. The tables uses 3 different ODBC drivers.(Wavecrest CView, MySQL, and SQL Server. Wanting to use universal data links(UDL) to save...

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...