Search results for query: *

First off this is not my database I am just fixing a report. I have two tables with following relevant fields. Table 1 AR_Detail Fields AR_Detail_Id, P_Id, Trans_Type, Posting_Stamp Table 2 Assessed_Values Field Value_Id, P_Id, History_Id, Assessed_Value, Change_Date Their only related field...

Such a rookie mistake thanks Andy.

After upgrading from previous version of Access to Access 2013 I get "Run-time error '3021': No current record.". When I debug it high lights the rec.MoveFirst. Dim rec As Recordset Dim db As Database Dim strFullBillingBase As String strFullBillingBase = "SELECT FullBillingBaseFile.*, *...

I have a report that is grouped by a field that contains different types of changes. On one of change types I would like to hide or suppress some fields that are irrelevant to the group. Is there any simple ways to accomplish this?

Thanks I would never have gotten that

I need to make a query to get the last comment for each account. Each record has a timestamp I can use to find the last comment. The table is called tblActions, primary key is Action Id, the fields I need are AccountNo, DateOfAction, and Comments. The query I tried is SELECT...

I have an Access Database in which a user will import a table to get payments from. However the file being imported for some accounts may have more up to date information on it such as names and addresses(Any differences will be more up to date). There are a lot fields making it hard to...

Knew it was going to be something simple like that

My program works fine opening up a word document, filling in the formsfields and printing out the document. Is there as way to have it go to specific printer that is not the default printer? Here the code if needed. Dim oWord As Object ' <-- Microsoft Word Const DOC_PATH =...

Sorry the format function worked for me.

It still rounds down with PHV answer. I neet it to round up.

i have a simple formula that goes like this curPenalty = Round(txtGross * 0.05, 2) curPenalty is a variable set to currency and txtGross is a field set to currency with an auto decimal place. When txtGross value was $261.70 * 0.05 would equal $13.085 rounding should make it equal $13.09 but...

Once in a while I will find 2 sheets printed on the printer, one sheet just has the message "HEAD / HTTP\1.0" and the other has 3 lines "GET / HTTP/1.1", "Host: 172.20.41.60", and "Connection: close". The printer is an HP LaserJet 4100dtn and is networked. I don't know if this is a printer...

The printer I was trying to print to broke. So I tried changing printer port to File: and saved the print job to a file. How do I open it or print it to another printer? The file it saved as has no extension and comes up as garbage when I open it up any program like word, notepad etc.

For some reason, I no longer get the export wizard when I try to Export a table to a text file. I've used it many times before but now when I hit File, Export, and choose text file from the save as type drop down box, it just saves it as whatever i name it, as delemited text file with quotation...

Sorry let me give the a better explenation. Somewhere between opening the form and running a procedure under a command button I need to make sure every record in the main table has a subrecord.

Thats what I had in mind, but can I do this without setting the forms record source to a query like that.

You can create a seperate database and link it like you said. Then go to tools menu, startup and uncheck everything and set a switchboard or the form you want the user to use in the Display/Form page: combo box. NOTE: Once you save the database like this and close and reopen it, your new...

I have 2 tables, joined in a one to many relationship. Is there any way I can test to see if every record in the main table has at least one record in the subtable before allowing the user to run the forms procedures?

thanx carrr for your quick response