Search results

Hi I have created a crosstable that counts using week number columns. However I really want to count everything within a week, but with a week ending on a sunday. ideally showing column headings with just the sunday date, but a count of all orders within that week. can anyone...

I have a bizzare problem. I have a small access 2013 database, which has only 10 tables I split the database, to give me a front end and back end. And then I had the problem here http://stackoverflow.com/questions/27029455/split-ms-access-database-cant-open-backend so I fixed it by renaming...

To follow on from an earlier post, I am trying to run an sql stored procedure from access. I was directed to use ADODB. I think I now have a very simple problem. How do I get the parameters back into access. My sql code is below, I am trying to get value back of the new record I have...

Hi, I am having problems trying to execute a stored sql procedure. It gives me an error 3065 Cannot execute a select query. The vba code is Dim qdef As DAO.QueryDef Set qdef = CurrentDb.CreateQueryDef("") qdef.Connect = CurrentDb.TableDefs("dbo_sites").Connect qdef.SQL = "EXEC...

Hi, I have set up a macro that sends an email with two reports attached. I can run the macro from a command prompt with . "C:\Program Files\Microsoft Office\Office14\msaccess.exe" "C:\Temp\ReuseProductionReportsV2.accdb" /x emailreports I can also run the macro through a scheduled task with...

Hi, I am trying to get a report that shows both column totals and row totals. I have a crosstab query that gives me the Row totals along with the crosstab data. I have read on a previous post http://www.access-programmers.co.uk/forums/showthread.php?t=195471 That I can union the crosstab...

Hi, I have a form that allows a user to complete a stock take. I would like to stop other users from receiving or despatching stock while a stock take is in progress. Is there a way I can lock a table, or stop users adding or altering records that match certain criteria. i.e. don't let users...

I am stumped with this one, I have been trying to work out what is wrong for a few hours, but need some help please. The code is as follows. Private Sub TxtGoto_AfterUpdate() On Error GoTo Err_Handler Me.StockSuccess.Visible = False MsgBox "before ifs" If (TxtGoto & vbNullString) =...

Hi, I have created a relatively simple access 2010 split database, for managing production and stock control using simple £35 Bluetooth barcode scanners so the users don't have to type the barcode number. It seems to work ok at the moment. I want one user to enter some information on a mobile...

Hi, Hopefully someone can help, to date I have used these forums quite a bit, but never posted. I am very new to access so please excuse any daft questions. I have created a database, and want to print an excel template we have, and populate some of the cells with access fields. I have...