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

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

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

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

I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine. This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and...

I am trying to create a function which will use variables to extract which fields are needed from an SQL statement and therefore retrieved via OpenRecordSet. Public Function DoSomething(pName As String) Dim PrtSthg As String Dim pr As DAO.Recordset Dim tray As String PrtSthg = "SELECT ID...

I am using the "folderexists" function to determine the location of the backend. This is followed by tableDef functions to relink the database with the backend. the folderExists function is a custom function I found on google, and it works but makes start up incredibly delayed. If...

I am creating a colour coded check list for pending invoices, I have made a continuous form, and placed a box behind. The box will become a different colour depending on the status of the invoice If IsNull(Me.Total_Due) Then 'Invoice is still open e.g. unfinished Me.BackBox.BackColor =...

Hi guys, I've developed an invoice tool which I've made 100% automatic and fool proof. All known errors are captured and dealt with, all forms are polished, all I's dotted and T's crossed... There is just one thing I can't make automatic... installing the database across the 3 sites which use...

urm, yeah... I've been tackling with a form for a while and kept coming up with a "cannot go to specific record" error... I decided to check in the tables to start again - and it turns out it adds nearly 1,000 blank records before giving me the error. - so after deleting nearly 100,000 blank...

I am trying to add up a list of dates that match a criteria... a search box result. I have tried DCount, and now I'm doing it through SQL, and no matter what combinations I try I still get an error - usually 3075 - Syntax error (missing operator) But I can't find anything missing - I copy the...

I was searching the internet for the best way to add 'smart' navigation, and I thought I'd share my make-shift solution. Apparently it's not very obvious? I am talking about the "first" and "last" and "next" and "previous" buttons which annoyingly will go to a new record if it's the end of...

It's an annoying, random occurrence, which has no apparent cause. I have a search tool which opens when the application begins. It begins with an Open event: Private Sub Form_Open(Cancel As Integer) Me.SearchBox.Value = Me.SearchBox.ItemData(1) Me.Requery End Sub Followed...

My server provider is telling me that my server is Linux and I would have to upgrade to windows to be able to connect my database to the SQL... so i figured, if there was a middle man who could collect the information and pass it along? Is there an add on of sorts to allow access to behave...