Search results

I am trying to build a form, which will be an Invoice when I sell a product. I have 3 tables called tbl_Customers, tbl_COrders & tbl_Parts and I have created a SELECT query with all the fields I need for the invoice. (see image). I have created a Form which will eventually be my invoice. When I...

I have 2 combos called Event & Sub_Event that filter a list called verses according to the input of the combos. It works to an extent, but it works on the text in the combo and I want to filter based on it's ID. Here is the staetment in the query: There are 2 columns in the combo tables...

I am trying to design a form to send an email, which I based on a Helpdesk database code I found on the web. I am not at all confident at writing code, so I may need some help. This is the code so far: Private Sub Command12_Click() Dim stWhere As String Dim varTo As Variant Dim stText As String...

I have a grid of postal prices in a spreadsheet grid for which I want Access to evaluate the correct value for the 2 criteria that I enter. The columns are zones which I have called: STD_Z1, STD_Z, STD_EU and ECO. For each of these columns I have created 12 records which represent the weights of...

I have created a form that will be printed as an invoice. As I have already invoices which I produced by other means I had th create a calculated expression for the invoice number. The expression is: =[OrderID]*2038 I'm sure at one time is was working as I have a printout when I was testing...

I am developing a database to track my eBay sales and I have written an expression to work out the cost for International postage, based on the zone they are in. I have decided to display 2 different text boxes for the 2 postage zones. The cost is determined based on the weight. Here is the...

This should work, but doesn't:banghead: =[Total Costs]*[Qty],<<< this extends the the line total =Sum([Total Costs]*[Qty]), <<<this should add up all of the line totals. The Total Costs*Qty Text box is called 'LineTotal', so I also tried Sum([LineTotal]). Both don't work. Can't see whats...

I am trying to write a query to list any items whoes dates are less than today. The following expression evaluates whether the expression is true or not and gives either 0 or -1 as the result. Expr1: ([Date relisted]+30)<Now() If I put either false or even -1 in the criteria it does not evaluate...

I am trying to SUM the values for Profit in a report from a value derived using an expression. When try to create a Total, using Design Totals, Sum is greyed out. Is there another way I can total these values. I have tried doing it in a Query but that was unsucessful.

I am developing a database to track my items on eBay. I have 3 fields that calculate the total fees I pay to eBay - Insertion Fee + Final Value Fee + PayPal Fee. I created it using the Expression Builder as instructed when I created the new field, but after saving the table and checking the...

I have a database that i have used for many years, which I use to analyse my bank statement which is in an Excel file. The query uses some code which uses a Combo box to look at a particular category to analyse. Here is the code: Public Function fCboSearch(vCboSearch As Variant) If...

I have created a database that I want to make a Runtime version from. I have gone to the Save and Publish and clicked on Make ACCDE file but when I save as it reports: That it is unable to create an accde, .mde or ade file. Looking at the help it suggests there might be too many tables. I have...

I have a form that sets up all of the necessary content that is being passed to the report. But I also want to set the Font, Font size and Font color, before the report is produced. Also a requiement would be that the font list must be the installed fonts on the computer. Does anybody have...

I am designing a database to add greetings card verses to a database. Attached is the relationship between the tables. I have writen an Event procedure, but it says 'Invalid Operation' (Error Number 3219) in the following code on the strSQL line: Private Sub Cmd_Add_Rec_Click() Dim dbs As...

I am trying to set the orientation of a form using VBA. The information as to which orientation is contained in a table, which is filtered to choose the correct report. See my previous post: Formating Text box in Report from a Form I have found on MSDN that you can set the Printer Object...

I have a form that when I select options in 2 unbound combo boxes and click a button that opens another form and is based on a query which checkes the selection in the 2 combo boxes. This is the criteria: Like fCboSearch([Forms]![Frm_Verse_Cbo]![cbo_Evt]) and a similar one for the other combo...

I am trying to position a text box on a report using the Left, Top etc properties. In the form which opens this Report are some text box fields which contain the position value. Even though the button calling the report is on the form, it errors saying ' Microsoft Access cannot find the...

In the Macro object 'ExportwithFormat' there is an option to output as an html file. There is also an option to supply a template file. I am not sure how to create a template file for html. Can anyone advise how to create this file or point to a resource that will help me?

I am trying to create a query to check 12 dates which are in 2 tables, using the expression Between Now() And Now() +30. I did not want the user to have to have any user input, so I created 12 queries for each of the fields that needed to be checked. I ran all of these queries in a Macro, but...