|
More site info...
MDBMakers.com - Powered by vBulletin - www.mdbmakers.com | Site profile
|
|
Site profile page for http://www.mdbmakers.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.mdbmakers.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.mdbmakers.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on MDBMakers.com - Powered by vBulletin:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
21
|
65
|
221
|
|
Post:
|
44
|
137
|
471
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for MDBMakers.com - Powered by vBulletin (http://www.mdbmakers.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
MDBMakers.com - Powered by vBulletin posting activity graph:
|
|
http://www.mdbmakers.com Alexa graph:
|
Top authors on MDBMakers.com - Powered by vBulletin during last week:
user's latest post:
Access 2007: Change in Creating...
Published (2009-12-17 17:45:00)
Joe I followed your steps and the same thing happened to me. I've passed this on to the MS Access team as a bug. I'll let you know if I hear back.
user's latest post:
SendKeys
Published (2009-12-17 12:13:00)
No problemo, glad it helped.
user's latest post:
Prompt user if a word starts...
Published (2009-12-12 05:10:00)
I think I have most of my questions figured out on how to do what I need. However, the below code seems to be the place where I need the help. I'm sure its how I'm searching for the word "other*". Any ideas because all it does is open a message that it does not exist and displays the " no help" message. BTW the column is correct as checked by the immeadiate window to make sure.. It does pick up the...
user's latest post:
How difficult is it
Published (2009-12-16 13:41:00)
I'll give that some thought, thanks again.
user's latest post:
SendKeys
Published (2009-12-17 12:11:00)
Thanks so much. A nice simple answer. Works great!
user's latest post:
File Menu Missing in Access 2003
Published (2009-12-11 05:17:00)
I have tried a number of methods also but this one worked for me too. Thank god. Thank you
user's latest post:
function on event
Published (2009-12-14 15:13:00)
Very interesting. Firstly, I did check the references - they were all correct (and same versions as what we develop with, etc.) The application uses DAO heavily; so if DAO were missing - aside from it showing up as "broken" - the app wouldn't even be able to pull out of the driveway. But if not properly registered would cause "funky little errors", then that may well be the explanation. I'll see if...
user's latest post:
Access and the WEB?
Published (2009-12-18 17:29:00)
I have a new project of having field people log in daily information through the WEB and use Access to do it with. After reading several postings, I am still lost. I hear people that uses Access on the WEB with great results. If this is so where do I start and what do I need? I will have many people putting information into the database and will need to generate data for payroll, invoices, etc. I have been given Office FrontPage to do this in...
user's latest post:
DoCmd.OpenReport filter...
Published (2009-12-16 15:36:00)
Thank you, Bill, that's exactly what I needed. That looks like the same syntax used in a VFP sql query.
|
|
|
Top 10 active forums on MDBMakers.com - Powered by vBulletin during last week:
|
|
Top 10 forums on MDBMakers.com - Powered by vBulletin:
|
|
|
|
Latest active threads on MDBMakers.com - Powered by vBulletin:
Started 5 days, 7 hours ago (2009-12-17 14:06:00)
by joe
Very close. The last 9 characters on my version are: 6425.1000
I'll see if IT will let me download the latest Service Pack.
I just verified that this only appears to happen when using the Expression Builder or entering the expression using Zoom. It does NOT happen if typing directly into the Field box in Query Design View.
So try this and see what happens:
1. In Query Design View...
Started 4 days, 4 hours ago (2009-12-18 17:29:00)
by Richard M
Access and the WEB?
I have a new project of having field people log in daily information through the WEB and use Access to do it with. After reading several postings, I am still lost.
I hear people that uses Access on the WEB with great results. If this is so where do I start and what do I need? I will have many people putting information into ...
Started 6 days, 6 hours ago (2009-12-16 15:13:00)
by wrmosca
There really isn't a need to do that if you use CurrentDB.Execute "queryGoesHere".
What code are you using, or if you are using a macro what are its settings?
Started 1 week, 1 day ago (2009-12-14 21:05:00)
by schuster
Quote:
Originally Posted by gix
Hi,
Is it possible to have a button on a for that when pressed adds 1 to a textbox.
I would like to have the button that adds 1 to the value of a text box everytime it is pressed. The text box has a number data type
Thanks
Gix
You can also use the spin box ...
Started 6 days, 6 hours ago (2009-12-16 15:09:00)
by wrmosca
Will
When you use a variable in a filter you have to concatenate it like this:
Code:
DoCmd.OpenReport stDocName, acPreview, , "fsalespn = '" & stSalespn & "'"
And also notice how I had to surround the variable in single quotes just like you do in a WHERE clause. If the field fsalespn were a date it would need octothorpes (#) around it like this:
Code:
DoCmd....
Started 1 week ago (2009-12-15 15:14:00)
by wrmosca
So you want to make existing data read-only? If everything is accessed through forms, set the form's properties to not allow edits or deletions.
Started 1 week, 1 day ago (2009-12-14 16:15:00)
by misscrf
That did it. I used the len one.
Thanks!!!
Started 1 week, 1 day ago (2009-12-14 14:48:00)
by misscrf
Can you check the library references that are enabled on one of the pc's with the code working and the one where it doesn't? In the module window, go to Tools | References. I am just curious to see if you might be missing a library reference.
|
|
Hot threads for last week on MDBMakers.com - Powered by vBulletin:
Started 1 week ago (2009-12-15 15:14:00)
by wrmosca
So you want to make existing data read-only? If everything is accessed through forms, set the form's properties to not allow edits or deletions.
Started 6 days, 6 hours ago (2009-12-16 15:13:00)
by wrmosca
There really isn't a need to do that if you use CurrentDB.Execute "queryGoesHere".
What code are you using, or if you are using a macro what are its settings?
Started 5 days, 7 hours ago (2009-12-17 14:06:00)
by joe
Very close. The last 9 characters on my version are: 6425.1000
I'll see if IT will let me download the latest Service Pack.
I just verified that this only appears to happen when using the Expression Builder or entering the expression using Zoom. It does NOT happen if typing directly into the Field box in Query Design View.
So try this and see what happens:
1. In Query Design View...
Started 1 week, 1 day ago (2009-12-14 14:48:00)
by misscrf
Can you check the library references that are enabled on one of the pc's with the code working and the one where it doesn't? In the module window, go to Tools | References. I am just curious to see if you might be missing a library reference.
Started 6 days, 6 hours ago (2009-12-16 15:09:00)
by wrmosca
Will
When you use a variable in a filter you have to concatenate it like this:
Code:
DoCmd.OpenReport stDocName, acPreview, , "fsalespn = '" & stSalespn & "'"
And also notice how I had to surround the variable in single quotes just like you do in a WHERE clause. If the field fsalespn were a date it would need octothorpes (#) around it like this:
Code:
DoCmd....
Started 1 week, 1 day ago (2009-12-14 16:15:00)
by misscrf
That did it. I used the len one.
Thanks!!!
Started 1 week, 1 day ago (2009-12-14 21:05:00)
by schuster
Quote:
Originally Posted by gix
Hi,
Is it possible to have a button on a for that when pressed adds 1 to a textbox.
I would like to have the button that adds 1 to the value of a text box everytime it is pressed. The text box has a number data type
Thanks
Gix
You can also use the spin box ...
Started 1 week, 1 day ago (2009-12-14 14:52:00)
by misscrf
try this:
[SubFrmA_FlexReports].Form![cboGroup_] .value & cnt
I am sorry if I am off. I don't know that I understand what cnt does with your srt =
Started 4 days, 4 hours ago (2009-12-18 17:29:00)
by Richard M
Access and the WEB?
I have a new project of having field people log in daily information through the WEB and use Access to do it with. After reading several postings, I am still lost.
I hear people that uses Access on the WEB with great results. If this is so where do I start and what do I need? I will have many people putting information into ...
|
|
Size: 1,315 bytes
