Search results

I am just formating it on the form in the properties, then converting it when the user clicks a command button to print to pdf.

Yes I can do that, then how do I format it properly? I tried just making it a string and then making that string = to the date textbox. That didn't work of course.

Hello All, I have a nifty automatic pdf printing scheme set up using pdf995. I use criteria from the reports themselves to name the output files for the pdf. On one of the reports they want the date to be a part of the filename. When I try to base it on a date field on a form (the form where...

Hey everybody, I have been posting a lot about my constant troubles with record corruption. I would get one line of bizzare characters and that record would be lost and I would have to go to a backup to retrieve it. I tried all of the suggestions offered to me, even the nitpickiest ones and the...

I use a program called pdf995. There is a VB module that you can use that comes with it (on the website) that allows you to specify where to save the pdf, check if there is a proper folder (we do it based on company name), if there isn't a proper folder it makes one and names it based on the...

Hello all, I have a form that takes info from another form and then adds some from it's own data and then it proceeds to print a bunch of reports based on what tests were done etc. When I just print them (With preview) I have a function in the first report that prints (in its Close event) to...

I believe you can just create a query that has the multiple tables in the query. Then base your form on the query and it will add the data into the appropriate fields in the appropriate table.

I had this same problem and I can get the rich text box to work with a little update but I haven't found anything to make the Common Dialog activex work. I have been searching the Knowledge base for days. I assume I have vb6 (that's what is said in the properties of access). I have OfficeXP. I...

Oh my. I am blind. Thank you. Greg

Hello all, I would like to have a richtextbox for, well, rich text formatting. I have looked everywhere, searched here, microsoft knowledge base, developers network, etc. I have the RICHTX32.ocx and it is registered but I can't figure out how to get a richtextbox. How do I get the control so I...

Oh... Yeah... A little tunnel vision I suppose. Thank you very much. Greg

Hello all, I have a report that prints different pages based on the testing required. This is done by having company info and general info in the page header of the report. The main worksheet area is in the page footer area and the various headings that are used for the different tests are...

The ldb file has only been there for a couple of the corruption issues. I turned off automatic updates so I'll let it sit and see if that does anything. I still wonder if AVG could do something. Maybe I should get a new network card and see if that does anything. I don't know. This is...

RV, The database is split FE/BE. there are usually 3-4 users at a time. I have no Idea how reliable my network is (don't really know how to test this). I have searched the forums and haven't found any help. Concerning the users shuting down without closing access: I just noticed that one of...

Hello all, This is stricktly theory but I am wondering if any of you have had any problems with losing records while running antivirus software on a network type solution. i.e. AVG antivirus that uses one computer as the main server and all operations for antivirus software updates etc are run...

Hello all, In our company we send off a lot of reports for a given sample. Sometimes the office folks need to do a specialized report with tables and other formatting. They would like to be able to a: be able to have another report where they could just write stuff, comments, etc about the...

So here is an update of what I have done. I got it to work once. I did some futzing and now it doesn't work. I think it has something to do with the way I am setting up my combo box on the form the qry is referencing but I can't figure out what made it work that one time. From what I...

That didn't quite work. I at least don't ge blank queries. It only shows the one compnay from the combo list. Shouldn't that name in the combo be enough for it to recognize others with that same name. The company is Pacific resourcing, shouldn't it be able to recognize Pacific Accounts...

Hello all, Is there a way to use the "like" statement in a WHERE clause but the like you are referencing is a field on a form? Example: Under the criteria of a query: Like "Forms!frmEmailListByCompany!CompanyCombo*". The bosses want to be able to choose a company from a list and print all...

I believe you have to start your reference with [reports][ReportName] etc. I think you are just missing that first [reports] telling it that you are looking at a field in another report. I'll double check. Scratch that. You don't need that for the subreport reference. From what I've done in a...