|
More site info...
Microsoft Access Help | Forum profile
|
|
Forum profile page for Microsoft Access Help on http://www.aspfree.com.
This report page is the aggregated overview from a single forum: Microsoft Access Help, located on the Message Board at http://www.aspfree.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Microsoft Access Help" on the Message Board at http://www.aspfree.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Microsoft Access Help:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
46
|
176
|
579
|
|
Post:
|
92
|
387
|
1,430
|
|
|
Microsoft Access Help Posting activity graph:
|
Top authors during last week:
user's latest post:
[Forms] Help with VBA + Access
Published (2009-12-19 14:53:00)
Did you solve the issue? Bar code data entry, interesting but I have no experience with it. Does it preclude binding the textboxes to recordset fields? Can't the StockCode and Qty textboxes be bound? Do the form/subform have master/child relationship set up?
user's latest post:
[VBA] What is more efficient?
Published (2009-12-17 21:58:00)
If you're contemplating an operation so complex that it would matter at all, you almost surely should be using some other kind of logic, perhaps a Select Case statement, or a different approach to your problem.
user's latest post:
[General] Creating a button in...
Published (2009-12-20 07:27:00)
I have knocked together a quick example for you... If you take a look at the Code Module, then open the form in design view and look at the button properties and look at the on click event. This will hopefully point you in the right direction. Post back if you have any trouble.
user's latest post:
Email Access Report With...
Published (2009-12-12 04:39:00)
I Kind of understand whats going on, but can you provide me with an example, ive tried passing values from one form to another with docmd.openform, but i am not able to pass, lets say a date from a form called, frmBydate containing txtstartdate, and txtenddate and i want to pass this value to docmd.openreport where conditiion, also how would i pass multiple criteria, with the Where Condition? I really need to know this, any help is appricitated
user's latest post:
[General] Creating a button in...
Published (2009-12-18 07:11:00)
Hi, I have enter the code as stated. When I tried to test the button I got the following message: 'The expression On Click you entered as the event property setting produced the following error: Only comments may appear after End Sub, End Function or End Property. * The expression may not result in the name of a macro, the name or a user-defined funtion, or [Event Procedure]. * There may have been an error evaluating the function, event...
user's latest post:
Unlock/Close Application
Published (2009-12-11 10:46:00)
Quote: Originally Posted by JPR Hello, I have a db on a shared server. Sometimes I need to make changes and users currently using the db, forget to close the program. This does not allow me to make my changes as it is in lock status. Is there a way I can close or unlock the application used by other users? Thank you. If you have admin rights on the server which the document is hosted on you can terminate a session a client has with a...
user's latest post:
Show howmany records there are
Published (2009-12-13 05:53:00)
i have found a solution i had a counter to show how much there is in a table a only had to ajust something a it works the way i want. thanks for your reply
user's latest post:
Show howmany records there are
Published (2009-12-13 10:42:00)
Here is an explanation of the dcount function for you http://www.techonthenet.com/access/functions/domain/dcount.php Alan
|
|
|
|
Latest active threads on Microsoft Access Help::
Started 23 hours, 7 minutes ago (2009-12-21 20:37:00)
by June7
Do you have macros or VBA behind the buttons? If VBA, post the code. If macros, I would have to see the project. I don't use macros, but I can usually figure them out. Can't attach to posts until member 30 days. Could load your project to a file share site such as Box.net (free, if file not too large) and I will look at. Post link to the file (without the http:// prefix).
Started 1 day ago (2009-12-21 18:47:00)
by don94403
You need to use parentheses to make it clear how the logical operators apply. Any time you have both OR and AND operators in an expression, group the logical expressions, otherwise you are likely to get erroneous interpretations of what you mean.
Started 1 day, 1 hour ago (2009-12-21 18:43:00)
by don94403
What are the structures of your 3 tables?
Started 4 days, 21 hours ago (2009-12-17 21:58:00)
by don94403
If you're contemplating an operation so complex that it would matter at all, you almost surely should be using some other kind of logic, perhaps a Select Case statement, or a different approach to your problem.
Started 5 days, 9 hours ago (2009-12-17 10:29:00)
by Fowler_ko
Take a look at the following thread, this should hopefully point you in the right direction:
http://forums.aspfree.com/microsoft-access-help- 18/open-pdf-from-access-169106.html
Started 4 days, 4 hours ago (2009-12-18 15:23:00)
by June7
Is there some reason the textboxes are not comboboxes with drop lists to choose the UserID and StaffID from and bound to fields of form's recordset?
If the form's recordset is editable and includes fields from tblLoan then can set the value of the recordset's fields: Me!fieldname = textboxname
Or use DoCmd.RunSQL method to execute SQL Insert and Update statements to add record...
Started 4 days, 15 hours ago (2009-12-18 04:18:00)
by June7
I might have a partial answer for you. Regarding second question - I have passed a recordset to a procedure and only declaration in the receiving procedure is in the procedure's arguments. Example: Private Sub Conversion(strTestNum As String, rs As ADODB.Recordset)
For question 1 I suspect No and for question 3 I would guess Yes. I will be interested in any other responses to ...
Started 1 week, 6 days ago (2009-12-09 19:42:00)
by June7
Sounds like you need to construct the break date for each query. Use DatePart function.
You want one period to start from 1941?
Try something like (the BETWEEN/AND is inclusive for date range).
for 1941 through 6/30
"BETWEEN #1/1/1941# AND #6/30/" & DatePart(" yyyy", Date) & "#"
for 7/1 through 12/31
"BETWEEN #7/1/" & DatePart("yyyy", Date) & "# AND #12/31" & ...
Started 4 days, 1 hour ago (2009-12-18 18:33:00)
by June7
Situation update (new post because can no longer edit my original): Don't know why, but now users are seeing the user-defined buttons in their copy of the frontend. I have no idea what changes I could have done that caused this. Guess I will call this resolved.
|
|
Hot threads for last week on Microsoft Access Help::
Started 5 days, 9 hours ago (2009-12-17 10:29:00)
by Fowler_ko
Take a look at the following thread, this should hopefully point you in the right direction:
http://forums.aspfree.com/microsoft-access-help- 18/open-pdf-from-access-169106.html
Started 1 week, 6 days ago (2009-12-09 19:42:00)
by June7
Sounds like you need to construct the break date for each query. Use DatePart function.
You want one period to start from 1941?
Try something like (the BETWEEN/AND is inclusive for date range).
for 1941 through 6/30
"BETWEEN #1/1/1941# AND #6/30/" & DatePart(" yyyy", Date) & "#"
for 7/1 through 12/31
"BETWEEN #7/1/" & DatePart("yyyy", Date) & "# AND #12/31" & ...
Started 1 week ago (2009-12-14 23:00:00)
by June7
I built forms and ran your code and I don't get errors. I have had forms corrupt. Try rebuilding one or both forms.
Started 4 days, 15 hours ago (2009-12-18 04:18:00)
by June7
I might have a partial answer for you. Regarding second question - I have passed a recordset to a procedure and only declaration in the receiving procedure is in the procedure's arguments. Example: Private Sub Conversion(strTestNum As String, rs As ADODB.Recordset)
For question 1 I suspect No and for question 3 I would guess Yes. I will be interested in any other responses to ...
Started 1 week ago (2009-12-14 20:25:00)
by don94403
Quote: Originally Posted by tunkerton Just offhand, does anyone know of a way to autosort new records as they're entered in an Access DB other than creating a macro? I'm trying to group User ID #s together so that the people doing data entry won't have to search for matching information on peoples' files.
You set off the alarm bells! You should never, ever ...
Started 4 days, 21 hours ago (2009-12-17 21:58:00)
by don94403
If you're contemplating an operation so complex that it would matter at all, you almost surely should be using some other kind of logic, perhaps a Select Case statement, or a different approach to your problem.
Started 4 days, 4 hours ago (2009-12-18 15:23:00)
by June7
Is there some reason the textboxes are not comboboxes with drop lists to choose the UserID and StaffID from and bound to fields of form's recordset?
If the form's recordset is editable and includes fields from tblLoan then can set the value of the recordset's fields: Me!fieldname = textboxname
Or use DoCmd.RunSQL method to execute SQL Insert and Update statements to add record...
Started 1 week, 5 days ago (2009-12-10 19:40:00)
by June7
Sounds like you need a query that will return the Max appointment Date for each admission. Try (my test of data worked):
SELECT Patients.Patient, Max(Patients.Appointment) AS MaxOfAppointment, Patients.Admission
FROM Patients
GROUP BY Patients.Patient, Patients.Admission;
The dates are not showing in standard format. What datatype are the fields?
Started 1 week ago (2009-12-15 14:41:00)
by June7
Found a link that has suggestion: http://forums.devx.com/showthread.php?t=73648
I tested with this code in a button click and works:
Dim x
x = Shell("c:\windows\explorer.exe c:\Program Files", vbNormalFocus)
You want to open to a V drive. You assume everyone using your project has a mapping to a V drive. This may not be the case. Are you going to map this drive letter on...
Started 1 day ago (2009-12-21 18:47:00)
by don94403
You need to use parentheses to make it clear how the logical operators apply. Any time you have both OR and AND operators in an expression, group the logical expressions, otherwise you are likely to get erroneous interpretations of what you mean.
|
|
Size: 430 bytes
