Search results

Well I'll be! It worked a treat! I didn't know you could use a query (i.e. Between # And #) to create a relationship in SQL! How clever!! tblOrderDetails.OrderDate BETWEEN tblFactors.DateRangeStart AND tblFactors.DateRangeEnd <- this was the bit I needed, I've customised it for what I...

Price * tblFactor.Factor WHERE [Forms]![Order Details]![DatePaid] Is Between [tblFactor.DateFrom] AND [tblFactor.DateTo] This is the closest I have, but it makes no sense to access.

Im getting quick confused and wound up. - after 3 days of trying several methods I can't seem to figure this out? I have a table of numbers that apply to a date range, for example: between 01/01/2001 and 01/01/2002 - The number (factor) is 20, Between 02/01/2002 and 01/01/2003 - the factor is...

In the real world, we have a set of numbered invoices. No 2 invoices have the same number, and no invoice goes missing or thrown out. If it's cancelled it is labelled so. So on to the database version of the invoice - Currently my invoice number is generated by the very rough...

I discovered this from a template I downloaded for a completely separate reason. Basically, in the caption of the button, place an ampersand ( & ) in front of the letter you want to short cut on your form, for example: a caption of &Next, will display a button with the word Next, but the N...

I've lost the website I found this on, but it has solved my issue. I've drawn the lines using code instead of physical lines. However I spent so long perfectly spacing them out, I just used the Left property of each line to position them. I believe this method is the tidiest, easiest way to...

The On Format event works, but it's only taking the height of the first record, and ignoring the rest, but is still applying the height. For example, I put feed the height into a text box control to find the height. The first record is 452, the subreport has 2 records. The second record's...

At the moment I am playing with verticle lines, although it will help with future things... I have scoured the internet and found many different ways of doing 1 single task, I need to simply resize my verticle lines in print preview. 1 main issue is the details section has a sub report which...

I am trying to create a "common product" short cut button. Basically an update-able list of products that you select and various fields and sub fields are filled in (as if by magic). For example, the description for ID=1 is Poster, and I want the button to fill in the field of description...

Thats perfect nanscombe. I really appreciate the annotations too, to help me understand how to get around it, and I've learnt something about SQL along the way!

Thankyou vbaInet, I have found all I can about OrderBy but it seems to only sort the form, and not control objects (e.g. my List box) within the form. I have tried the following combinations: Private Sub SortListBy_AfterUpdate() Dim SortString As String SortString = CustomerID If...

I would double check what type of field your combo is linked to, General or Text have different effects. Does the combo list add entries to a table or to a control, I'd suggest linking it to a table to then control the entries better. It may not be a solution, but I hope that helps.

I have a list box populated by a query, which in turn is populated by a text box - a custom made search tool basically. I want to create a drop down, or maybe a series of buttons to enable someone to change the sorted column, and sort type. Most tutorials on the internet tell me to edit the...

I'm guessing this has been spoken of many a time on the internet but the only information I could find was about mySQL on a server. Unfortunately my Host does not permit external access to the mySQL database (i.e. it will only let webpages on that domain access the data) This is unfortunate as...

I see - so there is no way of keeping the data in a back end - they will still have to be appended into one table eventually? Although plausible it makes things trickier in ensuring the linked data are also kept in sync (e.g. making sure key fields are matched in imported data tables)

Hello everyone, I am struggling to think of a solution. Basically 3 branches each use their own back end and front end, but now it's time for marketing, and I need to create a front end database out of all three back ends. The past 2 marketing exercises I've exported into Excel and manually...

Thanks Plogg, that's exactly what I needed - worked a treat!!!

It's frustrating me, and I've been on google for hours and still no closer. I need to work out sums of departments and group by year, but the year falls between 01/08 - 31/07 and not 01/01 - 31/12. I know how to work it out by year, but I'm trying to make it dynamic, so as more data enters the...

Would linking the excel to the access mean that data changes in Excel would affect the data in access? Data needs to be solid, e.g. not move around or editable after import.. I was thinking of making a basic template excel file so users can fill the spreadsheet and click "import" without a...

I was following some advice on normalising my database, and one key point, which now makes sense, is putting addresses in their own table. This now means I can categories addresses and have multiple addresses per customer, e.g. shipping, billing, marketing and home. It also saves data - for...