I'm not sure at which point the code crashes, it doesn't enter debug mode, Access stops working, and needs to be shutdown.
It would be much simpler to sort if it crashed normally!
James Bowyer
Last Activity: Feb 4 '14, 12:00 PM
Joined: Nov 2 '10
Location: England
-
OutputTo acreport crashes access when filtered
I need to only print one page of a report, not the whole thing, but do so automatically. Annoyingly, I can't seem to get it to work!
This:
works ok, but prints out all reports, not just the one I want.Code:DoCmd.OutputTo acOutputReport, "rptmouldcurrent", acFormatPDF, "C:\Temp\Test.pdf", False
So, I tired this:
...Code:DoCmd.OpenReport "rptmouldcurrent",
-
Long time between posts, but, we've compacted and repaired both front and back end, and are now trying to use it on a non terminal services machine, but no matter what machine we use, some forms still open blank, despite them appearing fine in the tables. Any other reasons why this should happen?Leave a comment:
-
Its on a terminal services server, so rebooting is going to be fun (but necessary!), completely forgot about compact and repair, so I'll try that first, on both front and back ends.Leave a comment:
-
Access 2010, MDB file format. 15MB back end db size, but thats lots of tables, no attached files.Leave a comment:
-
Too many records? Or something else
A database I created a while ago is now having problems with new records, they are saving properly, and show up in the tables ok, but when you try and go back into them, they are showing up as blank. However, earlier records aren't. I'm beginning to think that there may be too many records for Access to cope with, but I though there was no limit (within reason). There are currently just over 1300 rows in this table, and 42 columns, of which one is... -
Fortunately I've just discovered my spare machine, despite being 64 bit, has a 32 bit access install. Which is helpful.Leave a comment:
-
I'll try and look into the virtual machine idea. Its bizzare, I've created databases on my 64 bit machine which work fine on other computers, which I'd always assumed to be 32 bit, and I've never had an issue until now with a 64 bit or 32 bit machine (in fact, I'm pretty sure the machine that I originally created it on was 64 bit, although the install of Access must have been 32).
Why can't everything just work?!Leave a comment:
-
Access 64 bit is already installed on my PC, Could I install a 32 bit version on my machine?Leave a comment:
-
Running a 32 bit database on a 64 bit machine
I have a database I originally created on a 32 bit machine, which needs the front end updating, but my computer is 64 bit, and so therefore none of the code runs. However, I don't want to convert the database to 64 bit if I can help it, as all the machines it will be running on are 32 bit, I just need to edit it. All are running Access 2010, and windows 7.
Is there any way of editing it on my computer? Or will converting it to a 64... -
Date comparing Problem
I'm having a problem where two dates that (I think) should be able to be compared against each other (I'm trying to narrow down a set of results by a date to/from). However, it doesn't seem to work.
To add confusion, if I make the input text box an Unbound box, with a data input mask instead, it works.
Which is all very well, but the calendar that pops up when you click on a Date box is rather essential in this case,... -
Hi Pat,
Yes that does help! I was hoping that I would only need to define the variables in the top subroutine, but never mind, not too much of a hardship! I assume that same would be for recordsets that I have called?
JamesLeave a comment:
-
Procedure Too Large Error
I have a (very) complicated bit of calculation script which has just come up with the error "Procedure Too Large"
Clearly, I need to split it into smaller subroutines.
However, having never done this, I need to ask a few questions.
1. are any variants and recordsets that I have called in the initial subroutine still accessable as normal?
2. are subroutines that run within subroutines counted... -
I got Run time error 438: object doesn't support this property or method"
Using it in this way:
...Code:Private Sub Command0_Click() Dim ExcelSheet As Object Set ExcelSheet = CreateObject("Excel.Sheet") ExcelSheet.Application.Visible = True ExcelSheet.Application.Cells(1, 1).Value = "Customer" With ExcelSheet .ActiveWorkbook.Worksheets.AddLeave a comment:
-
Creating multiple Excel sheets (same workbook) from Access
I am using the following code to create an excel sheet:
...Code:Dim ExcelSheet As Object Set ExcelSheet = CreateObject("Excel.Sheet") ExcelSheet.Application.Visible = True ExcelSheet.Application.Cells(1, 1).Value = "Customer" ExcelSheet.Application.Cells(1, 2).Value = [CustomerName] 'Again repeated lots of times for various different values ExcelSheet.Application.ActiveSheet.Protect -
Ah, apologies, I should have marked it as closed!Leave a comment:
-
Fixed it,
used Instr in the following way:
which then differentiates between the two values.Code:Dim areastring As String areastring = Me.CboxArea Dim searchingfor As String searchingfor = "IG" Dim test2 As Variant test2 = InStr(1, areastring, searchingfor) MsgBox test2
Leave a comment:
-
Criteria in a dlookup to look at part of a cell only
I have the following code
Which I am using as a test to differentiate between values in a combo box.Code:Dim test As Integer test = DCount("area", "Baydetails", "Area='IG'") Select Case test Case Is = 1 MsgBox "Island" Case Else MsgBox "Wall" End Select
The values either start with IG or WG, followed... -
Brilliant, tried the first one, and it Worked!
I am more used to using SQL within VBA, hence why I had written it as I had, I knew there must be a way of doing it in normal SQL.
Thanks Very much.Leave a comment:
-
Apologies, the full code is:
and is...Code:SELECT BayDetails.Department, BayDetails.ShelfHeights, BayDetails.Variable1, BayDetails.Variable2, BayDetails.Variable3, BayDetails.BayWidth, BayDetails.BayNumber, BayDetails.Height, BayDetails.BaseDepth FROM BayDetails WHERE (((BayDetails.Side)='Left')AND ((BayDetails.JobNumber)='" & Me.JobNumber & "')) ORDER BY BayDetails.BayNumber DESC;
Leave a comment:
No activity results to display
Leave a comment: