dsatino
Last Activity: Apr 27 '17, 05:59 PM
Joined: May 3 '10
Location: Wilmington,DE,USA
-
go into design view, right click the field, and look for conditional formatting. From there, just build the expression. -
paste this into a module and call the function when you need it.
...Code:Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Public Function fOSUserName() As String 'Returns the network login name Dim lngLen As Long, lngX As Long Dim strUserName As String strUserNameLast edited by Rabbit; Oct 24 '14, 07:12 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Leave a comment:
-
I would definitely use an array and loop through those.Leave a comment:
-
This makes no sense to the machine:
stWhereConditio n = Report.rptRMSta tus.RecordSourc e = "qryRMStatu s1"
I'm surprised it doesn't throw an error.
Anyway, it should look something like this:
stWhereConditio n="([YourDateField] Between #1/1/2014# AND #1/31/2014#) AND [YourMatNoField]=12345"
The bracketed items refer to fields in the report recordsource.Leave a comment:
-
I've done this in the past, on two separate occasions using two different techniques. In both instances I used access as a front-end interface, a form to select the fields, and an SQL server as the back-end. It's been several years so I'm going to just have to give the general gist. One is going to far simpler to implement, but not as all-encompassing from a user standpoint, while the other will give them anything they want but it's an extensive...Leave a comment:
-
How to connect to sql server express with PHP
I'm new to PHP, but probably expert with databases. I'm very familiar with connection strings, objects, ODBC, etc.
For some reason I can't seem to accomplish this simple task in PHP. My guess is that it's something easy, but it eludes me. My 'site' is hosted on my PC, which is probably the problem since network config is not a strong suit for me.
In any case, here's what I have:
MS Surface running windows 8.1... -
You're really going to need to show some visuals of your forms and code to get any feed back on this.
On the surface, it sounds like you're getting more elaborate with your forms/code then you need to be.Leave a comment:
-
Just as a suggestion, you may look into doing it the other way around.
Excel can connect to a database and query it just as Access can.
http://office.microsoft.com/en-us/ex...010099664.aspx...Leave a comment:
-
Admittedly, I've never written an app in VB, but it sounds like you'd be undertaking a fairly major project. Basically, you'd be writing an entire application from scratch.
I think you'd be better of just packaging your front-end. The only real drawbacks are that access doesn't adjust itself to various screen resolutions and you'd better have all of your errors trapped.Leave a comment:
-
Assuming your failure is in setting the string variable...
Change all of you double quotes to single quotes. Then wrap the entire string in double quotesLeave a comment:
-
It's probably much simpler than you think. It sounds like the last record isn't updating because the control update event isn't being triggered.
My guess is that your form is continuous and that hitting the enter button moves to the next record, which does trigger the event. On the last record, there is no where to go and so the enter button does nothing.
I'd bet that if you simply take the cursor and select any previous...Leave a comment:
-
Did you try the joined sql in a query outside of the report? If it works there and not in the report, then it has to do with how the report works while 'printing'.Leave a comment:
-
Well, the 'unknown' db engine error is almost certainly related to your SQL statements. I would test them individually in a query and see which one fails. Then figure out why it fails...probabl y syntax.
Also, it's probably cleaner to just write some custom functions to return the values rather that have multi-layered sql statements.
I'm not even sure of what your percentages are supposed to be representing. Percentage of...Leave a comment:
-
In access, a reports orientation is at the report level and not the page level, so no.
Acrobat is essentially the same, except that you can merge pdfs into a single document and the orientation of the individual pdfs will be maintained so you can, in this way, get a blended orientation document.Leave a comment:
-
Yes. You can basically do whatever you can dream up...and there are usually ten different ways you can accomplish it.Leave a comment:
-
Is the record failing to update in the form bound table, or just in the 'larger' table?Leave a comment:
-
Why not just set the .recordsource of the form to the table and bind the form fields to appropriate table fields. Then you're editing the records directly and don't need the update query.
Basically, you're adding an extra step that's not necessary.Leave a comment:
-
First, I don't see where you're actually assigning the string variable to a text box anywhere.
If you've simply left that out because of it's obviousness, then there are a couple of easy trouble shooting actions I would take.
1. Stick the dlookup() function in the immediate pane and see if it actually returning something. If it isn't, then you know you've mis-spelled the foreign name. if it is, then:
2. debug.print the...Leave a comment:
No activity results to display
Leave a comment: