Recent content by robsant

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

thanks! that did the trick. imported all tables to a new container, then deleted all links in front end, and created new links to the new container. all works fine now!

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

Solved it! I was being daft, I removed the recordset part and just executed it as a command and it all worked. I also changed "1, stDestination" to " , adParamReturnValue"

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

Many thanks for the help, I have rewritten it using ADODB. I now have another problem with returning paramaters, but I assume its best to post this as a new thread.

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

Great thanks, I used the cross tab to total the rows and a report to total the columns.

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

Solved it thanks Cronk. Your suggestion, with a bit of tidying of the code, and modifying the control source on the form fixed it.

What also baffles me is that I am 95% sure this was working before I changed a couple of fields on the form. Could that have caused this ? Or what else could I have changed that stopped this from working ?

Sorry, I didn't understand what you meant. I read the help file / documentation , also have tried to read several sections of different access books, searched the internet, tried compacting and repairing, tried changing the sets to use an sql rather than findfirst, all prior to posting this...

I am still confused, I tried to copy the code from elsewhere where I have used it successfully, then modified it slightly. Elsewhere I used: If (TxtGoto & vbNullString) = vbNullString Then Exit Sub Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "[BarcodeNumber]=" & TxtGoto If...