Search results

I am trying again with the centralising my back end database, to be accessed by three main sites... I've heard about sharepoint since office 365, and it seems to be the best option for hosting the database, but there is very little information about it. I thought it was a bit like the...

apologies again, it was such a simple answer. I still get confused where '#' are needed when referring to dates. Retrieving a date from the table didn't need them, but writing a date to a table did, so when it updated itself with the new date, it would just paste a number and reference it as a...

Apologies for not being clear. rs.fields(22) points to EndofMonth date field in tblBranch, which is formatted as short date in the table properties For some reason, when I try to retrieve the date from the field (30/09/14) I get 00:00:00 instead. Subtracting 1 day from this throws an error and...

I am trying to create an automated "End of Month" report which prints when an end of day report is printed, but it's also the last day of the month. It follows some simple conditions: 1) Find the last day of the month and stamp it in a table 2) If the last day is a Sunday, then stamp the...

I was searching to find a way to turn messages off when running a pre-saved query, and came across dbs.execute Dim dbs As DAO.Database Set dbs = CurrentDb dbs.execute "SOME SQL STATEMENT", SOMEERRORFUNCTION Not only does it turn off the messages, but also removes the need to Dim, and I might...

ah - I thought I found the solution, but it turns out, you can't use the same subform twice... that's annoying. Plan B: make a big subform to include all 6 days

I am creating an end of week report, which needs information from Sat-Fri, so basically it will be one sub form, but used 6 times. I'd prefer not to have to make 6 subforms, with 6 queries, but rather using 1 subform and 1 query 6 times. For example, on the parent form, I will add the...

I have a report, with a sub report. The sub report has a determined height, and can't grow or shrink. It has enough height for 25 rows, which will never be filled for this purpose. I need a totals box to appear after the 25th row, but it will only show at the bottom of the list, regardless of...

Right - I found a way around, but I want your opinion on the efficiency. I basically have queries, referring to other queries... The first query lists all my Z1 numbers with InvoiceIDs: SELECT InvoiceID, Z1Number FROM tblInvoiceQuote WHERE (Z1Number)=Z1()); Z1() is a function to retrieve the...

I did make the report using the query in a previous version of my db, but the report only shows the departments with sales on. For audit purposes, the report needs to show £0 for the other departments.

tblDept: DeptNo | Dept 01 | Dept01 02 | Dept02 03 | Dept03 ... tblOrder: Z1Number | Price | Dept 1000 | £10 | 01 1000 | £10 | 01 1000 | £12 | 02 1001 | £100 | 03 Report: (Z1: 1000)...

thats right.

So I have 17 departments, and each need to be summed up grouped by a number (Z1 number) - a unqiue number which changes with each business day. I eventually need a report to display all 17 departments, whether a sale has gone through or not. I am trying this from a different angle, but I need...

I think you misunderstood my db structure... let me see... [tblOrder] ---<[tblDept] tblOrder: OrderID*, Z1Number*, DepartmentID (FK), QTY, Price tblDept: DeptNo*, DeptName In reality, my table is more like: [tblInvoice]---<[tblOrder]---<[tblDetails] [tblOrder]---<[tblDept] I simplified it for...

I have a list of departments, 1-17, where each needs a SUM of their price for each end of day. At first I was going to make 17 queries, and place each into a new sub-report, but there must be a way to list all 17, even if they haven't had a sale put through. I've tried linking using "show all...

I am implementing a till system, which works fine and everything, but it's replaced a standalone till which was very limited and difficult to program. The calculations are straight forward for the End of Day and End of Week... 1. It adds up the sales for each department (20 in total) 2. It adds...

I am confused why the forums were saying to run TableDef, but I just placed an error around a DLookup. I think my way is easier and more straight forwards, or is there something I am overlooking? Updating the system for Marketing returns, currently the system doesn't have a column for that, so...

I need to create a message box or a form or something to flash on the screen to tell the user that a piece of "Update" code is running. the update code will be updated reports from marketing returns, but the 3 branches who use the information are separate so I am creating an update form to...

I was looking for a way to update tables remotely, one issue I had was I had to invent a new column in a table. Which was straight forwards, using the "ALTER" SQL command. Obviously, I only want this to run if the column didn't exist already. I searched for "How to tell if column exists in...

is the email plain text or HTML? I have had to set my body text with basic html tags, such as <font size=12pt> and <b> ... It may be worth using <p> ... </p> tags, or <br/> tags within the bodytext code??