Search results

I receive Access MDB files by email. I also use Zone Alarm firewall which is set to quarenteen files with MDB extensiosn. The quarenteened file has extension .ZLH. I can load the file ok but after I make changes, how can I save it under a different name and in the mdb format. The file menu...

I completed a search for my question with no answers. I have searched Access help and still no answeres. Here is my problem. I am helping my son, who is 400 miles away, with Access application for a small business. He sends me the most current mdb file for me to work on. In the mean time he...

I did a search with my question and found no solutions that work. I have a report that lists and counts the jobs and amtBilled in the currenet month. The first day of the month there are no jobs listed in the querry. The report writer (print preview view) in the details footer gives err on all...

I have need help on something I can't solve. I have a main table Dispatch (I have sence learned that I should have named it tblDispatch plus other nomenclature no-no's) which has pertinent fields of source, date , AmtBilled, Amt Credit and AmtPaid. The other table is Source which has all the...

I have a querry to list sources and the total amount due. The Table is dispatch, the fields used are source,AmtBilled,AmtCredit,AmtPaid SELECT DISTINCTROW Dispatch.Source, Sum(Dispatch.AmtBilled) AS [Sum Of AmtBilled], Sum(Dispatch.AmtCredit) AS [Sum Of AmtCredit], Sum(Dispatch.AmtPaid) AS...

I searched for count in this forum and read all the resulting posts. None do exactly what I want and I am not proficient in the VB codint to edit them to fit my needs. I have a main form Dispatch which I need a text box to count the dispatches for the current month. I have a querry that lists...

I have searched both the querry and forms fora but can not find the solution to my goal. I am trying to get a default textbox invoicenumber (field name of the text field) that is one greater than the last entry. I chose a text field because the user may include in the future characters in the...

I have looked at the recent post concerning queries with date criteria and muddled through those from a search. From these I have learned a lot. I am almost where I want to be in my query. Here is the SQL SELECT Dispatch.Date, Dispatch.Invoice, Dispatch.[PO Number], Dispatch.AmtBilled...

My experience is with dBase code. I can generally follow VB but cannot write VB code from scratch. I ran a search in this forum for dbase code and found no answer to my question. Can I run dbase code in Access? Is there a convrsion utility? I have MS VB version 2, standard edition on the...

I use report writer to print invoices on a page. The report writer has report header- not used; page header - not used; and source header which has all the mailing information. The detail section list all charges. The source footer sums the amount due. The page and report footer are not used...

I have a db that stores info on autobobiles. THe pertinent tables are: Maketable - one field labeled make Modeltable - two fields labeled make, model In the main form I want to have a lookup combo box for make and then have a lookup table for model which shows only the modes for the make...