Here's the function (based on http://www.tech-archive.net/Archive/Access/microsoft.publi c.access.forms/2008-10/msg00851.html):
Code:
Public Function AddWorkDays(OriginalDate As
angi35
Last Activity: May 17 '09, 05:58 PM
Joined: Jan 29 '08
Location:
-
Thanks for the ideas. I googled and found a function that does work in theory, but now I'm trying to figure out how to connect this function/module to the code in my form. I haven't worked with functions a whole lot, so I'm still figuring this out.
Here's the function (based on http://www.tech-archive.net/Archive/Access/microsoft.publi c.access.forms/2008-10/msg00851.html):
... -
Working with work days
Hi,
I'm working in Access 2000. I have a form with a series of date fields, showing the progress of a project from start to completion. There's a set of fields/controls for projected dates (when the project is projected to enter each stage of the process) and another set for actual dates. For my purposes, I'm only working with the projected dates.
There is a formula, based on the size of the project (how many hours... -
So... answering my own question (partially), I wrote the queries directly into the VB code. But I'd still love to know if there's a way to use VB code to run an existing query without having to rewrite the whole query....Leave a comment:
-
I'm getting an error message:
Runtime Error 3129
Invalid SQL statement
Expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
It's highlighting line 2 in the code. Any ideas?...Leave a comment:
-
It's all coming together now. Thanks for the help! One more question... what is the code to tell the form to run the append query (and delete query) I created? I haven't figured out how to do that.
Thanks,
Angi...Leave a comment:
-
But I'm creating a report other users will be running. If the data changes in the original table, won't users have to manually recreate the local table each time they want to run the latest report? Or at least run an append query to add any new records to the existing local table (and then would the db automatically number the appended records, or would that have to be done manually as well?)?Leave a comment:
-
Drat... I'm working with linked tables from an external (non-Access) database to which I can't add fields.Leave a comment:
-
Thanks for the idea.. I'm afraid all that did was freeze up Access so I had to Ctrl+Alt+Del to close it. I've double-checked that I correctly named all my tables and fields in the code.
I don't know if this will help, but here's an example of the data in Table2:
ItemNumber, ItemAlias, LatestUsedDate
123-04, Bear,
123-04, Zebra, 8-12-05
123-04, Tiger, 6-12-07
123-05, Leopard,
123-06,...Leave a comment:
-
Selecting most recent records for a query
Hi - working in Access 2000... my goal is to combine fields from two tables in a query:
Table 1 has ItemNumber and ItemDescription . There's only one record per ItemNumber.
Table 2 has ItemAlias. It also has ItemNumber and LatestUsedDate.
Table 2 may not have any record for an ItemNumber in Table 1; it may have one record; or it may have several records for a given ItemNumber.
Sometimes the LatestUsedDate... -
What a relief. It works. I figured it would be something like this, but the whole null/empty/zero-length string thing makes my head spin, and I just could not get Access to understand what I was trying to tell it. Really appreciate the help!
AngiLeave a comment:
-
Trouble with zero-length string error using OpenArgs
I'm having a zero-length string problem... Hoping someone can help. (This is in Access 2000.)
In FormA, I have a button that opens FormB with OpenArgs. In FormB, the OpenArgs are translated into default values for certain controls.
FormB is a continuous form. For this reason, I can't assign .Value -- it has to be .DefaultValue. Otherwise it changes the values in the first record in the form.
If any... -
I have some follow-up questions and I want to attach the test database again, but I can't figure out how. Do I need some kind of permission from someone to attach a file?Leave a comment:
-
Thanks ADezii! This is really helpful.
Angi...Leave a comment:
-
Certainly. Let's see if this helps:
In tblBids:
[Sales] [BidNumPt1] [BidNumPt2] [BidNumPt3]
AB 08 001 1
DG 08 001 2
NM 08 001 3
AB 08 002 1
DG 08 002 2
NM 08...Leave a comment:
-
Referencing a query in VB
Hi all - I've been working on this from various angles for days, and I'm pretty well stumped at this point. Hope someone has some ideas. Working in Access 2000...
I’m trying to write code to assign a 3-part identifier to each new record.
The 3 parts are:
BidNumPt1: two-digit current year (BidNumPt1 = Format(Date, “yy”))
BidNumPt2: three-digit incremental number based on the year (Pt1) and the salesperson... -
Thanks... all plausible answers!
It can't have to do with whether I'm logged in or not, because on a daily basis people are using this database before I get in in the morning. What's more, the backend is on the general server that everyone uses for practically everything. Yet this file was the only thing not working (or so they tell me).
I doubt it has to do with the system administrator doing work on the server, since...Leave a comment:
-
Database went read-only for a day
Yesterday (while I was out sick), the Access 2000 database I've been refining and further developing for a company suddenly went read-only for a day. Near as I can tell, it's the backend that went read-only. Everyone could get in through their frontends (which are on each workstation computer), but no one could add or change data.
Today it's working fine.
I'm hoping there's some explanation other than it missed its... -
Hi Nico,
I'm trying, but I'm afraid I'm not really getting the idea. First off, where do I put this function? I mean what event do I attach it to? How do I make it run?
Also, I don't think the "ExportFold er" field from the code you sent in your first post is doing anything. That's supposed to be the place that saves the path to the folder I select, right? -- so that the next time I click the btnGetFolder, it will...Leave a comment:
-
Hi ADezii -- It depends on what you mean by 'interact with them'. If you mean sharing data between the database and the external file, no, there's no need for that.
The situation I have is that there's a section of my database that captures key engineering info on each job record. The engineering department has seen how in other areas of the database, other departments are able to click a button and open an external document that's...Leave a comment:
-
Well, the code is way beyond me, but I put it all in, and it worked. Amazing.
At least it partly worked. As I understand it, I should be able to go into the record, click the btnGetFolder and browse for a folder, then click "OK", and that path should be stored in a field in my table called ExportFolder that's also a control on my form. Then, I'm assuming, next time I click the button in this record, it should open the...Leave a comment:
No activity results to display
Leave a comment: