User Profile
Collapse
Profile Sidebar
Collapse
crazyhouse
Last Activity: Mar 3 '09, 10:41 PM
Joined: Aug 17 '08
Location:
-
Thanks, worked like a charm -
Print Access 2007 Attachment with VBA
Hi,
I dont even know where to start on this one. I found this on the net (everything in italics are the authors comments):
Code:Public Function OpenFirstAttachmentAsTempFile(ByRef rstCurrent As DAO.Recordset, ByVal strFieldName As String) As String Dim rstChild As DAO.Recordset2 Dim fldAttach As DAO.Field2 Dim strFilePath As String Dim strTempDir As String
-
Filter report by date greater than inputbox value
I am trying to view a report that has records that are filtered by date. basically all of the records that are greater than whatever date is entered into an input box. I would actually like to know how to give a start and an end date, but i figured i might be able to master that once i get the first code down. Here is what i cam currently using. ncrdate is a field from my table.
Code:Dim stDocName As String Dim mydate
-
Check fields from hidden form and change data on original form
Ok, so i looked up the information that i needed, but now I see that what i was trying to do was really made for a SQL statement.
Here is what happens. I open a form (hidden) with 20+ fields on it. Any of the fields may have a term on it. (MPI or LPI) <-- text obviously. If they exist in any of the fields, then i need to make a label visible on the form that is actually going to be used. Then the hidden form closes.
... -
-
thanks DonRayner, worked like a charm.
Dan2kx, it ends up being one record, but i guess it could have been multiple records. But you bring up something I am interested in. Can i get rid of the previous/next button in code..... so that it can be conditional. Instead of having it either load everytime or not?Leave a comment:
-
stLinkCriteria on multiple criteria, different types fo criteria
This is the line of code i am trying to use. It doesnt work. I want the form to open only records that match the inspectjn, and accqty isnull.
inspectjn is text
accqty is a number
Code:stLinkCriteria = "[inspectjn]=" & "'" & [strTrackingNum] & "'" And IsNull([accqty])
-
Maybe. I dont have very much experience with this. How many queries can i run in the recordsource, and how will i direct them to the proper field on the report. Maybe i dont understand completey. Will i be able to pull from more than 1 table... the recordsource only seems to allow 1 table.Leave a comment:
-
Run query from Report
I am trying to run a query from a report. I have gotten some help here before on setting up a query. This is what i am trying to run...
Code:SELECT tblHL.[Heat Number] FROM tblHL, Table1 WHERE (([hl]=[table1].[hl1]));
-
How to select a record from a different table based on info entered
I have 2 tables - tblCertData and tblHL
tblCertData includes multiple fields, but the ones that matter at this point are
[1HL] (number field) and [Matl] (text field).
tblHL includes fields [HL] (number field) and [MatlDesc] (text field)
On my form that writes all of its data to tblCertData there is a dropdown box for [1HL]. The info in this dropdown box comes from tblHL [HL].
I would like... -
Use custom function filtered information
I am using a custom fuction (I got the information from Microsofts site for the code)
Code:Function Median (tName As String, fldName As String) As Single Dim MedianDB As DAO.Database Dim ssMedian As DAO.Recordset Dim RCount As Integer, i As Integer, x As Double, y As Double, _ OffSet As Integer Set MedianDB = CurrentDB() Set ssMedian = MedianDB.Openrecordset("SELECT
-
-
I swear, i tried to change it but i couldn't figure it out. How do i make this work for a number field?Leave a comment:
-
-
Display message box when search is not succesful.
I am using the following code on a search page.
myvalue = InputBox("Pleas e enter the Tracking Number.")
stDocName = "Inspection_for m"
stLinkCriteria = "[tracking_number]=" & "'" & [myvalue] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acReadOnly
What i would like to know is how to open another form or msgbox if... -
OK let me explain how i got the Me.Refresh
from one of my previous threads, about updating a field from another field (part number, and description if you remember), on another table. I got it to work with a subfrorm that is hidden on the table. When a person enters the part number into the visible field it looks up the partnumber from the invisible table, after that point i had (in code) the visible description made equal to the...Leave a comment:
-
Sorry, i just realized that your comment said to use BeforeUpdate(), not after.Leave a comment:
-
Linq, if you dont mind i would like to get the answers from the questions in my previous post, but I decided to just make the other fields on the form disabled until the inspector name is entered. That way it HAS to be first.Leave a comment:
-
The bulk of it will be the different parts of a valve assembly
stem
packing gland
bonnet
and 36 other parts
each one will have a disposition that is one of these 3 (the fourth option that i talked about earlier really doesn't apply)
replace
rework
reuse
I had thought that i would make it look like the form(paper) that is currently used. I realized that...Leave a comment:
-
Does the me.refresh save the current form? The only reason that i am using it is because when i setfocus, the cursor wont actually move until the me.refresh occurs. I tried it without it, and the cursor did not actually move, when i put the me.refresh in there, it did. I am also populating other fields with me.refresh (using earlier fields in the same record to get their information). If there is another way of doing this, please inform me. ...Leave a comment:
No activity results to display
Show More
Leave a comment: