|Microsoft Access Forum||I want ot set up a count by Joseph M: Alex, Yes I did. I created a counter called ER1CNT which contains my iif statement and conditions. And at the end of my report I put a textbox with Sum([ER1CNT]. The Sum text box is blank. It prints no results. Reply from Alex Hedley: Try moving the IIF into your Query that is the source of your Report, I've just made a more...|
|Microsoft Access Forum||distributing FE of access database by Richard: Hi
i need some help on how to distribute the FE of an Access database to other workstation on a network. The complexities of my situation are as ff:
1. The workstation with the Access database used to be a Master at a diferent dept which has now been brought to our dept as a standalone to join our network.
2. l more...|
|Microsoft Access Forum||I want ot set up a count by Joseph M: Alex
I tried what you recommended and created a counter using an iif. My counter looks like this iif([date key]>0,1,0). I see zeros and ones get posted into the field but they will NOT sum up. If I use a sum field I get a type error. If I use a count field I get every record in the file not just the records in error.
Any idea more...|
|Microsoft Access Forum||Limit To List issues by Chad V: I've created a few Combo Box's with a Value List. I've entered the options in the Row Source. I've set Limit To List to No, so that users can enter in their own text if one of the options is not sufficient. But the user is not able to manually type something into this box. What else should I look for? Reply from Alex Hedley: There's a more...|
|Microsoft Access Forum||Inventory by T-Bone: Richard or Alex,
Are we ever going to get to doing the inventory seminar? Reply from Alex Hedley: Hi T-Bone,
Maybe my mind is playing tricks but I can't remember which Seminar you mean.
The main Access Courses are building up to the Inventory part using Recordsets etc.
|Microsoft Access Forum||Single Password by MBONGA: hello Rick
Could any one help me generate a single password in access database while distributing an access database to my client ?? Reply from Alex Hedley: Hi
Can you elaborate?
Are you wanting to lock down the db so only certain users can get in?
Check out the Security more...|
|Microsoft Access Forum||I want ot set up a count by Joseph M: I have a report that produces a message to the user when a record is missing data. I consider these conditions errors and I would like to produce a summery at the end of the report that shows how many of error #1, Error #2 ,etc. I am user an iif function to generate the error message but I can't seem to find a way to create an more...|
|Access Tip: Download Images from Web||Access Tip Download Images from Web by vinod singh: I like this products Reply from Alex Hedley: Thanks |
|Microsoft Access Forum||combobox by Margaret Bou Jaoude: I would like to create a combo box in my form listing the table or query fields with multi selection property, and I need users to chose and select the fields to export to excel or tho show in a report as they don't have to access my tables and queries. Reply from Alex Hedley: This is all possible but I'd advise a Listbox and not a combo box.
|Access 2010 Expert 1||Combo Issue by John Fass: Richard,
After watching Access 2010 Expert 1 video on Relational Combo Boxes I added a combo box using the combo box wizard.I selected the values from table option. I moved 2 fields over from the Available fields to the Selected fields side in the wizard.One field was the RoomTypeID the other was the RoomType. I chose hide the key column option. I stored more...|
|Microsoft Access Forum||Access 2013 transactions by David K: Is it possible to use workspace transactions within a master-detail form?
The master record is read-only with all the changes occurring to the detail records. Reply from Alex Hedley: You could set the Fields on the Main Form to Read-Only.
Then the detail or Sub-Form you can have as editable. |
|Access 2010 Beginner 4||Comment by Cindy Sloan: Craig, I noticed your question wasn't answered. The $ sign is not required because it is in front of the 2000, not somewhere in the middle, like this: 20$00. If you look in the Match box, it says Any Part of Field. That means it is only looking for the numbers 2000 in that specific order anywhere within the field. It will find 2000 in a field that contains $2000. Another example, more...|
|Access 2010 Expert 2||Comment by Jeff Perkins: Oh, and the fix for it is to just right click on the "_1" table and then click on "Hide Table".|
|Access 2010 Expert 2||Comment by Jeff Perkins: I know this is a late answer for your question, but since no one has answered it, I will go ahead.
What you are describing happens when you add a table(or query) to the relationship window that is already present in the window. So, if you add a CustomerT to the window when CustomerT is already there, Access marks it with the _1 suffix to tell the difference. I don't know why more...|
|Microsoft Access Forum||Missing Property Sheet by Phyllis R: When I opened my database on a remote computer, the datasheet was there, but off to the left. When I work in my office I sometimes use two monitors and I must have somehow moved the datasheet over to the other monitor which was off. I don't know how I did it, what a stupid mistake. I'm glad the issue is resolved, but I am sorry to waste more...|
|Access / Word Q&A: Format Currency on Mail Merge||Access Word Q A Format Currency on Mail Merge by Lyn: Thanks BenT; that worked a treat!! :))|
|Access / Word Q&A: Format Currency on Mail Merge||Currency field in Access not showing correctly in by Lyn: Thanks for the tips here but they are not working for me.
The Access database I want to use has other fields in it, so when I created a Query for the "Payment" field and inserted it, the rest of the fields wouldn't work.
So I tried the hint you gave for Word and it was easy to follow, more...|
|Microsoft Access Forum||Accessing data from the web by Donald W: Thanks for your answer, Alex.
I apologize for my delay in getting back to you.
I'm thinking the runtime might be the easiest. There will only be 6 people tops accessing the db. And there will be no input on there part. They will use it to run reports or queries I have built.
Thank you again,
Don Reply from Alex more...|
|Microsoft Access Forum||SQL Recordsource Criteria by Susan : I am currently using the following code to update another subform.
Private Sub Form_Current()
On Error Resume Next
Forms!MasterF!AssignF.Form.RecordSource = "SELECT * FROM AssignmentsT WHERE LessonID=' & LessonID "
What I would like to do is to add a second criteria. I want the subform to open the records more...|
|Microsoft Access Forum||Missing Property Sheet by Phyllis R: I can no longer open my property sheet when creating a form or opening an existing form. I even went back to one of my backup databases to see if it would work, but it doesn't. I don't know what I did, but I can't find the solution. Does anyone know how to resolve this issue? Reply from Alex Hedley: Have you tried a more...|