@NeoPa
I knew a proper programmer would find a better way!
@adyhart, in case you are a novice programmer, NeoPa's code is making use of Me.Person1 etc., being True/False checkboxes, which means they can be used directly to set/or unset the Enabled property of the Me.Person_Name boxes. Very neat!
S7
sierra7
Last Activity: Jul 8 '13, 08:14 AM
Joined: Sep 3 '07
Location:
-
-
Hi
Rather than setting Visibility True/False it might be better to set Enabled True/False, that way the fields are just greyed-out rather than missing altogether.
Your right in your assumption that you will need to run some code in both the On_Current eventy and After)Update events. It could be something like this
...Code:Private Sub CheckFields If Me.Person1 =False Then Me.Person1_Name.Enabled = FalseLeave a comment:
-
Thank goodness for that!
To do the count try copying the 'control' (i.e. the box with the current formula), then change the 'Pallet weight' to 1
The formula should sum the ones and give you your count!Code:IIf(Chute#1="CBOL - N/A", 1,0) +
S7Leave a comment:
-
Hi
The IIF() function consists of a 'test', then a value for if the result is true, and then a second value for if the result is false.
The zeros (0) in the code I posted were for when Chute#1 (etc) is not equal to "CBOL - N/A", i.e false. All values must be numeric if you want to add them.
I still can't see why you want to nest the IIF()'s on this occasion and you don't seem to be doing so in your sample...Leave a comment:
-
I don't understand the question. Sometimes you are using SUM and sometimes COUNT.
Are you doing this in a Form or a Report?
Does Pallet#1 correspond only to Chute#1, Pallet#2 to Chute#2 etc. Please confirm.
I think in essence you want the folowing but they are not nested;...Code:=( IIf(Chute#1="CBOL - N/A", Pallet#1Lbs,0) + IIf(Chute#2="CBOL - N/A", Pallet#2Lbs,0) + IIf(Chute#3="CBOL
Leave a comment:
-
Hi
As far as I know Excel 2003 had a limit of 65536 rows. Excel 2010 has over a million; 1,048,576 rows.
How many rows do you want to export? You can copy row by row but that is slow. This put row headers in, changes column widths and font of headers, then copies the data.
...Code:Dim x1 As Object ' OLE automation object Dim Db As DAO.Database Dim rst1 As DAO.Recordset 'first check that C:\extract
Last edited by sierra7; Feb 9 '12, 08:14 PM. Reason: Commented out references to Timer as sngStart etc. not defined in this snippet.Leave a comment:
-
This will be too long for a PS..
Obviously, you can read the mempory card if you extract it from the camera and insert it into a cardreader slot, as it's then assigned a drive letter.
I'm interested in developing this for astronomy, when it's too cold to go outside to the telescope! As the images are transferred to the pc OK I will just number them sequentially and store them locally (as well as on the memorycard), so finding...Leave a comment:
-
Hi
I'm stll looking into this for my own interest but making slow progress because of other matters.
I've abandoned Win7, for the moment because it would not recognise the camera, so nothing would work. I can confirm your findings that thing works much better in XP.
While still using XP I found that although I could see the camera in Windows Explorer I could not read from the memory card. However, there was a...Leave a comment:
-
OK, I seem to have been on the wrong track here! I had assumed that the extra driver required to give you WIA functilonality was installed by the Nikon software.
Silly me; you seem to have downloaded the WIA Development kit from Microsoft. There are full instructions and example code included in the kit.
The required dll is WIAaut.dll for the WIA Automation layer. When I came to copy it from the kit I found there was...Leave a comment:
-
Hi again,
If you say the code works in XP, I can't think there is anything wrong with the code per se, which I why I suspect a driver problem.
I've Googled 'windows 7 driver for Nikon L22' and found the a number of sites purporting to supply updated drivers. Note that there are 32 and 64 bit versions of software that have minor differences (What version of Access are you using? There are some issues with Service Pack 1 in the...Leave a comment:
-
@NeoPa
I'm not really miffed. However, this should have been (forgive me Stevan) a trivially easy question which the first post should have cleared up. (Most usually people create a report then ask the question how to restict it to a selection!)
Anyone searching the database for advice might overlook some of the issues revealed by this case. (If I really wanted to rant, I would pick on the search engine used on this site. I...Leave a comment:
-
Hi,
I'd like to gently point out that it was not NeoPa's suggestion that fixed the report, otherwise the issue would have been resolved last week.
What was wrong were the location of field controls in the Header section rather tah the Detail section.
S7Leave a comment:
-
I think it is working properly now. By putting the data in the Page Header you were getting the codes for the first record only and this was not changing on subsequent pages.
Each persons Location code must appear in the Detail section to associate the details for that individual. I've just remembered that I have not hidden the Location field but really you could use this instead of your 'member' control.
Note the position...Leave a comment:
-
OK, there are a number of issues.
The first is that although you are formulating and selecting a Location for the Master Record, it's not appearing anywhere on the report and all the other master data is appearing in the Page Header section.
It would be better to move all this heading into the Detail section. I'm still playing.
I also noticed that in the NonSerialized subreport the hidden Location field is in...Leave a comment:
-
OK
But I could not see a Location in the Master Record. I take it that Rank, LName, and FName are all there but in that case you have to specify them as
for both Mastcer and child fields, or create a 'Location' field in the same format as you used previously.Code:Rank;LName;FName
I'll take a closer look
S7Leave a comment:
-
Hi
A quick look shows that the two subreports are linked to the main report via 'Location'. (Link Master Fields / Link Child Fields)
Surely it should be SSN?
S7Leave a comment:
-
Hi
I've set up a test database to check this out. I was interested to see whether having/ or not having a Primary Key on the table had any effect. However, both versions add 6 x 6 'instantly'. (6 values over 6 records)
Is there any code in your form that Access is choosing to run first rather than doing 'housekeeping' and calculating the sums?
S7Leave a comment:
-
Hi again,
The answer is to include the identifier in strReportFile e.g.
However, refereing back to your other question about looping through...Code:strFilter = "[SSN] = '" & Me.MemberSelect & "'" strName = Me.MemberSelect strCurrentPath = Application.CurrentProject.Path strReportFile = strCurrentPath & "\NewReport" & strName & ".pdf"
Leave a comment:
-
Hi,
In that case I cannot see why NeoPa's first post did not work.
I imagine both your sub-reports are in the same Detail section ?
If you make a copy of the Master report, then delete the two sub-reports does it run properly.
If you then put in the PAGE BREAK do you then get one page per person?
Then add back one sub-report at a time and re-test. What results?
S7Leave a comment:
-
Hi.
I'm not a network guru but I know you can locate the backend in a folder on the server which is hidden to general uses. The front-end explicitly links to this file via the known folder-name but the users cannot see it to delete it or steal data by copying to pen-drive.
If they can get into what was the 'Database Window' they can stil wreck havoc.
Which reminds me that I must stop them pressing F11 in Access...Leave a comment:
No activity results to display
Leave a comment: