|
More site info...
Microsoft Access | Forum profile
|
|
Forum profile page for Microsoft Access on http://www.dbforums.com.
This report page is the aggregated overview from a single forum: Microsoft Access, located on the Message Board at http://www.dbforums.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" on the Message Board at http://www.dbforums.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:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
165
|
500
|
1,419
|
|
Post:
|
599
|
1,416
|
3,832
|
|
|
Microsoft Access Posting activity graph:
|
Top authors during last week:
user's latest post:
Flickering Pages
Published (2009-11-13 20:19:00)
Note also the 'flickering' might be due to the recordset requerying. I've never had to use any code to turn off any type of flickering (and wouldn't recommend it). Sometimes a Refresh command versus a me.requery versus a me.repaint makes a difference in the code. I did have problems once with flickering over a citrix connection for the users. I used unbound forms to resolve this along with changing citrix screen refresh...
user's latest post:
Change from IIF to Switch
Published (2009-11-13 16:48:00)
No problemo, happy to help. Some people count sheep, for you it's parentheses!
user's latest post:
Updating subform from field...
Published (2009-11-10 09:22:00)
Quote: Originally Posted by pkstormy I just finished re-editing my previous post. You may want to re-read it as I finished answering your original question. - sorry about that. Thanks pk, sorry for the delay in replying. This solution worked better than i could have expected you are amazing Thanks to all who have helped Keep up the good work
user's latest post:
Open report
Published (2009-11-13 12:32:00)
Dim strWhere as Integer strWhere = "[ID] = " & Me.[PatientID] DoCmd.OpenReport "rptPatients", acViewPreview, , strWhere If your primary key is a Text type field (not a Number type field), you need extra quotes: strWhere = "[ID] = """ & Me.[PatientID] & """" and of course Dim as a String
user's latest post:
Macros
Published (2009-11-12 19:15:00)
Or is it: Big ugly Office Button -► Access Options -► Current Database -► Overlapped Windows (under Document Window Options). (Access 2007)
user's latest post:
Weighted Average Function by...
Published (2009-11-12 09:41:00)
Good stuff. Now our problem. We can get this information, but putting it in to the form is the tricky bit. Is your form read only or do users edit the data?
user's latest post:
Flickering Pages
Published (2009-11-13 20:19:00)
Note also the 'flickering' might be due to the recordset requerying. I've never had to use any code to turn off any type of flickering (and wouldn't recommend it). Sometimes a Refresh command versus a me.requery versus a me.repaint makes a difference in the code. I did have problems once with flickering over a citrix connection for the users. I used unbound forms to resolve this along with changing citrix screen refresh...
user's latest post:
Progress Summaries
Published (2009-11-13 15:22:00)
so have a sub/child table which uses the memberID and a date as the PK by the looks of it a memberid + year + month could be a good candidate key.
user's latest post:
Flickering Pages
Published (2009-11-12 12:31:00)
You can use the echo method to turn off the screen refresh, and then turn it back on after your code is done. Fair warning: I strongly suggest having error handling such that if an error is triggered, your error handler will turn the echo back on. Otherwise you risk leaving echo off for the user's machine, which is exceedingly annoying.
|
|
|
|
Latest active threads on Microsoft Access::
Started 2 days, 18 hours ago (2009-11-12 12:13:00)
by Karen Day Registered User
I have an Access 2000 Database .
I have created a Search Page (made up of continuous forms) where the user clicks on the active record and then goes off to another form to find the same record number (as that which was selected on the Search Page) and display it. I then return the focus back onto the Search Page.
Effectively form A is open, I click on a button to open the Search Page (...
Started 2 days ago (2009-11-13 06:19:00)
by radder
Morning All
I am writing an Archive DB however its been some time since I tackledcode so I am a bit rusty. I am opening a form via a command button and on open I want the ID field to copy to the new form so that the records are linked. I am leaving both forms open to be safe but I keep getting an error that I can't assign a value to that object. Any ideas would be great. The code I have ...
Started 4 days, 21 hours ago (2009-11-10 09:07:00)
by rudeboymcc
Ok, but then when you open the form in the first place, where would it get its information from? At the moment, I use the filter like this:
Code:
Docmd.OpenForm "RM", ,, "[ID] = " & Me.ID
and as it's bound, it finds all the information and displays it. If it's not bound then I don't see when it will find the info. the form that opens it only has a list of names so it can't pass ...
Started 1 day, 21 hours ago (2009-11-13 09:23:00)
by Karen Day
Hi there,
I am using Access 2000.
I have Supervisor Table which has a combination index where no duplicates are allowed.
This means that when a record is created with the SiteID field and the CompanyID field and the SupervisorName field being the same as a previous record, then the current record cannot save and error messages are given.
I have created a Supervisor Details Form ...
Started 1 day, 17 hours ago (2009-11-13 13:57:00)
by kedunc
I want to add several additional IIf statements to the expression below and have been advised there is a limit of 7 consecutive statements for IIf so better to use Switch function to do the same thing. Have tried using Switch but keep getting errors.
Here is original IIF which works fine
Date Due: IIf([Course I]="Epilepsy Awareness & Rescue Medication",DateAdd(' m',12,[Date Completed...
Started 1 day, 16 hours ago (2009-11-13 14:21:00)
by dendalee
I have a youth database which holds all of the youth information for a facility.
I need to add a table that will track monthly progress summaries for each youth. Every youth (as long as he or she is a resident in the facility) will receive a monthly progress summary.
In Jan, Feb, Mar, etc. I need the field to show Yes, they've had a summary, or N/A ( not applicable for that month [...
Started 2 days, 16 hours ago (2009-11-12 14:39:00)
by benz1984 Registered User
Hello,
I have a search field in my database so I can searh my records by social security number. Well after the search is finished, it obviously it displays the record I searched for. Well, it seems to place a "filter" on the databse and in order for me to display all records again i have to close out of the form and reopen it again. So it displays record 1 of 1000 instead of 1 of 1 after ...
Started 1 day, 20 hours ago (2009-11-13 10:30:00)
by Jayde
I have a form that contains a button to open a report of the current data that was entered. The code that opens the report:
DoCmd****nCommand acCmdSaveRecord
DoCmd.OpenReport "rptPatients", acViewPreview, , PatientID = " & Me![PatientID]"
this code opens the report but when it opens it is blank. Can someone help me get this report to open the current record that was entered?
...
Started 1 day, 21 hours ago (2009-11-13 09:58:00)
by Amused
I'm generating invoice reports from raw data inported from our EPOS software into Access. Part of this data is a coloumn called Discription which contains a discprition of a product but is also used to record a job reference.
A sale may look like this:
123 1 1/11/09 Thing x1 3.00
123 2 1/11/09 widget x2 6.00
123 3 1/11/09 Job: Mr Smith x1 0.00
(where 123 ...
Started 3 days, 21 hours ago (2009-11-11 09:16:00)
by NTC
there is nothing defined as a 'group' within a form. it is within reports.
in forms; you would have to add a field to the underlying table and put in a value that identified which group a record is with.....and then modify your code to accommodate this grouping method.
|
|
Hot threads for last week on Microsoft Access::
Started 5 days, 14 hours ago (2009-11-09 16:37:00)
by nckdryr
Welcome to the forums.
I've used an approach similar to this in past projects. What I did was to generate an Append Query in VBA based on the user-input, and then ran that. If you need help writing SQL in VBA, I'd have a look at Martin Green's site .
HTH
Started 2 days, 18 hours ago (2009-11-12 12:30:00)
by rudeboymcc Registered User
Hi. Ive got a split form and I want to change the colour of some of the fields. With some fields I have done this using :
Code:
£#,##0.00;-£#,##0.00[Red];£0.00[Green]
In the "format" property however I do not see how to do this for a textbox with just text.
how would I do this?
Started 4 days, 21 hours ago (2009-11-10 09:07:00)
by rudeboymcc
Ok, but then when you open the form in the first place, where would it get its information from? At the moment, I use the filter like this:
Code:
Docmd.OpenForm "RM", ,, "[ID] = " & Me.ID
and as it's bound, it finds all the information and displays it. If it's not bound then I don't see when it will find the info. the form that opens it only has a list of names so it can't pass ...
Started 3 days, 22 hours ago (2009-11-11 09:04:00)
by Sinndho
The dollar symbol ($) probably is the culprit.
Started 1 week, 1 day ago (2009-11-06 12:44:00)
by RedNeckGeek
Why not make a table with just 4 fields?
Employee---Text
Date--------DateTime
Absent------Yes/No
Late---------Yes/No
Started 3 days, 21 hours ago (2009-11-11 09:16:00)
by NTC
there is nothing defined as a 'group' within a form. it is within reports.
in forms; you would have to add a field to the underlying table and put in a value that identified which group a record is with.....and then modify your code to accommodate this grouping method.
Started 4 days, 21 hours ago (2009-11-10 09:15:00)
by nckdryr
Quote:
Originally Posted by chris07tibgs
I am trying to copy one record, with the exception of 2 fields (which are not in this code) and move the end date to the start date in the new record. This code works exactly as I want it to....with the exception that it doesn't copy only the record I want, but also every single record in the ...
Started 2 days, 19 hours ago (2009-11-12 11:34:00)
by Eejit Registered User
I'm new to MS Access and I've been struggling over this for a couple of day's and have finally conceded that I need help.
I have a table , USERS, made up of ID(PK), UserName, Password
For test purposes I have the table populated like this
ID UserName Password
1........1...............1
2........1...............2
3........1...............3
4........2...............1...
Started 1 day, 17 hours ago (2009-11-13 13:57:00)
by kedunc
I want to add several additional IIf statements to the expression below and have been advised there is a limit of 7 consecutive statements for IIf so better to use Switch function to do the same thing. Have tried using Switch but keep getting errors.
Here is original IIF which works fine
Date Due: IIf([Course I]="Epilepsy Awareness & Rescue Medication",DateAdd(' m',12,[Date Completed...
Started 2 days, 16 hours ago (2009-11-12 14:39:00)
by benz1984 Registered User
Hello,
I have a search field in my database so I can searh my records by social security number. Well after the search is finished, it obviously it displays the record I searched for. Well, it seems to place a "filter" on the databse and in order for me to display all records again i have to close out of the form and reopen it again. So it displays record 1 of 1000 instead of 1 of 1 after ...
|
|
Size: 1,033 bytes
