PotatoChip
Last Activity: Feb 4 '11, 07:26 PM
Joined: Jan 28 '08
Location:
-
Excellent! Thanks for all the help/guidance! -
How to calculate 6 business days past a specific date?
I'm working in an Access XP database and I need to create a query which calculates what the date will be 6 business days after [Rescind_Date]. I have no idea where to start and most posts I find on calculating business days pertains to subtracting data in two date fields. I can build an expression in my query to add the date, Date_Due:[Rescind_Date] + 5 but that doens't address the business days.
Thanks in advance! -
I don't know what I was doing wrong but I copied and pasted your code into my form and it works perfectly!
Thanks so much!!!Leave a comment:
-
I tried what you suggested and it didn't work. I kept getting error messages and had to delete parts of the code.Leave a comment:
-
Custom Primary Key
I'm trying to work out how to format a custom primary key using the current year as part of the key. I've copied code which I use 'OnCurrent' for the form. The code I've copied is:
Private Sub Form_Current()
If Me.NewRecord Then
Me!RDNo = Format(Nz(DMax( "val([RDNo])", "TblDocumentReq uests"), 0) + 1, "000000")
End If
End Sub
What this should do (based on what it... -
I can't believe it was that simple.
I changed the column count and it copied the text but now the combo box selection doesn't stay the same for the record. So, on record 1 if I select 'Coma', and then go to the 2nd record and select 'sleep apnea', when I go back to record 1, the DraftCondition reads 'sleep apnea'. I need the DraftCondition to reflect what the user selects because it could be days or months before we figure out what the Condition...Leave a comment:
-
Copying info from a combo box
I have a form which tracks patient information. It has patient id, last name, first name etc as well as a field called Condition. The form also has a combo box called DraftCondition which is driven by a separate table called TblDraftConditi on.
What I want the user to be able to do is create a record, select a DraftCondition and then when we have confirmation of the Condition, update the record by copying the DraftCondition to the... -
So once my boss saw how I had managed to link the ChangeRequestNo (and that it worked perfectly), she asked if I could add another field for MemoNos and link it in the same way. So, I added the fields to the appropriate tables, created the relationships, added them on my form & subform and linked them as I have learned how to do. However when I update either of the fields(MemoNo or ChangeRequestNo ), they update perfectly until I go to a new record...Leave a comment:
-
It worked! I wish I was as smart as you at Access. I didn't even know that property existed. I've taken 3 courses in Access and the more I work with it the more I realise the courses didn't even scratch the surface in terms of what can be done and how to do it in Access.
Thanks heaps!!
PotatoChip.Leave a comment:
-
I didn't choose to omit [ChangeRequestNo ']; the wizard maxes out at linking three. I link the [DocumentType], [DocumentNumber] and [Version]. The subform lists all matching records as the subform shows where the documents were sent to so there can be multiple records.Leave a comment:
-
Linking form & subform information
Ok, I have a form and a subform. The form shows a document with it's pertinent information. The subform has some of the same fields as the form and shows where the document was sent.
The main form fields are:
Number, Type, Title, Version, EffectiveDate, Status, Owner, Reference, ChangeRequestNo , Comments
The subform fields are:
DDL_ID, Type, Number, Version, DocCtrlNo, Location, Returned, ChangeRequestNo
... -
Thanks for all the help!
ChipLeave a comment:
-
Fish,
Thanks for the link to the article. I think I understood it, which is a pretty good indicator of where I'm at in terms of computer literacy...*sig h*
I'll give posting the tables a shot:
[tblControlledDo cuments] - drives main form
Type, text(driven by tblType which has no PK), PK
Number, text, PK
Version, text, PK
Status, text
EffectiveDate, date/time
...and several...Leave a comment:
-
I don't fully understand how to post my tables and have it make sense. Most of what I do/read about in Access is totally over my head. I just tweak and play around until I get the results I need without being able to understand what I've just done. I'll just tell my boss it can't be done. I don't want to waste any more of your time. Thanks.Leave a comment:
-
Fish,
Will that work with two tables? My documents are stored in one table and the Doc_Ctrl_no is part of another. Perhaps I wasn't clear enough in my orginial post; the same document type & number can have the same DocCtrlNos, it just depends on the version. This is why in my main table, I have had to make the doc type, no and version as the primary keys. Believe me, gong show doesn't even begin to describe this database and...Leave a comment:
-
Controlling duplication in a subform
I have a form which shows information about our controlled documents. I also have a subform which tells you everything about the many places this document was distributed to. So, Form 1234 would have one record but for that form, there could be as many as 30 records in the subform showing that it was distributed to this, that and the other place. Within the subform is a field, Doc_Ctrl_No which is not the primary key and can't be the primary key... -
Sorry for the lack of clarity. I was ready to tear my hair out when I posted. What I wanted was a form to show a drop down list for the department which would then open the report based on the department selected, which was all based on a parameter query. However, trooper that I am, I gave up only to be told that the regular prompt for a parameter report was good enough.
Thanks anyways!Leave a comment:
-
Form for Parameter Report
I am working in Access 2002 and I have been asked to create a form for a report based on a paramter query so that the user selects the department from a drop down list on the form, query runs and voila opens your report.
Now, I have successfully done this, following the steps in a How-to I got off Microsoft's website, with just a form and a query. When I follow their instructions for the query-form-report, I get the form to open, select my... -
Thanks! At first it didn't work but then I played with it and taking out the Toggle bits seemed to do the trick! Lol...people at work think I'm some computer genius...little do they know...muhahaha !Leave a comment:
-
Hiding Subforms in Access
I have a form which tracks Change Requests. Sometimes documentation needs to be updated as a result of the change. So, instead of bogging down the form with mulitple comment fields, I have created a subform to input any affected documents. Is there a way to hide the subform (as the form is already quite messy and large) if no documents are affected? I was thinking if the user ticks a checkbox indicating documents are affected, the subform would show....
No activity results to display
Leave a comment: