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

Di not work when I tried to integrate it into my existing form, so decided to make it a sub-form.

Sorry I thought that was the one I attached!

Hi JHB Did you forget to attach frmPriceVertical? Can't see it in the post!

I have a problem! When I click on the Zones combo, instead of the value list, it lists all of the fields in the current form. I have checked the properties and it is definately set to the value list. I created the code as pbaldy explained, but I was confused about the FindPrice sub routine. I...

HI Thanks thats just what I was looking for! How is the code run as I could not see anything in the control source. I havn't done much code level programming so I'm not sure how it runs. I'm guessing that that it is attached some how to the form, so do you open the form and then add the code?

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

Don't know what was happening but I got it to work today using the expression [OrderID]+2038. I tried it yesterday and it gave the #Name? Error. The name property did not work! Thanks for your help! I think there was something weird going on with my PC one time it froze and I had to restart.

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

Don't know what was going on, but it works now?? I was choosing the zone then moving to a new field or even a new record, but it was not changing. Happened to close the form and noticed it had done the calculation. I have put a note beside it to press F5 which updates it immediately.

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

Don't know what was going on, but I had saved the changes several times as I changed the formula. I reopened the database after closing it and voila it calculated the total. I was tearing my hair out (haven't got much now), was getting frustrated after looking at this for an hour or more!

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

Hi Got it to work using this expression: Between [Forms]![Home]![Date_Test1] And [Forms]![Home]![Date_Test2] What I did not explain before is that I wanted to check if any of my listings on eBay had been relisted and had not missed any. The criteria above was on a calculated field which added 30...

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 found why it was not displaying a value! I had not set the Result Type and the Decimal places. Did not realise not doing that would result in displaying nothing!

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