I endorse what NeoPa says: there really is no practical alternative to creating a table of days with a flag set appropriately for each day. Another factor that you need to bear in mind is that holidays are not universal. Most are country specific and some are even region specific within a country.
Another thought: if you ever need to deal in daily working hours which vary according to the day of the week, or accounting periods which...
youmike
Last Activity: Nov 21 '08, 07:04 PM
Joined: Mar 15 '08
Location:
-
This batch file assumes that there are three generations of backup files,
numbered 1, 2, 3 in a folder called “Backups” on the “F” drive of a network machine called “Server”.
These folders must be created before running the batch file.
It also assumes that all data to be backed up is in a folder called “Data” on the “D” drive of a local machine
In any batch file, any line that starts with a colon(:)...Leave a comment:
-
Will; try to do in next 24 hoursLeave a comment:
-
If you are running a split database, i.e. front end with everything except the data and only data in the back end, my experience is that running a batch file to copy is not a problem.
I have one customer where we run several scheduled tasks at differing intervals - hourly, daily and weekly in this particular case - we had to use a backup the other day to deal with a power interruption issue and there were no difficulties.
...Leave a comment:
-
A first reaction. By allocating blocks of numbers to different states, I'd say that you are plannning to attach significance to what should be a pprimary key. A better strategy is to add a field called StateID to the table. You could use the pretty standard two letter code for each state. To do this, I'd suggest a second table called tblState with two fields, StateID and StateName. If you want to allocate specific numbers, then add fields for...Leave a comment:
-
To do this you simply set up a scheduled task in Windows, setting the repeat interval to whatever you wish. The scheduled task runs the batch file. The example I gave you is a version of one I use to run hourly. In this case there are more generations of folder, so that the risk of repeatedly backing up a corrupt file is reduced. As part of this strategy, separate daily and weelky tasks are also run.Leave a comment:
-
Another suggestion: I use a VBA module, which I call modVersions. In it I note version numbers and dates of introduction of each of those versions and notes on what has changed. Here's an example:
...Code:Global Const gcstrModule As String = "PAR" Global Const gcstrVersion As String = "08133" '*** 07001 10 Sep '*** 07002 14 Sep ' LU_Staff corrected ' StartUp options activated.
Leave a comment:
-
Having looked at Stewart's example, I'd just add one thought about choice of font. Apart from specifying the width and spacing of the bars, the 3 of 9 spec also prescribes where the human readable numbers should fall in the image and the size of start and end characters which have to be included in the string. Look at any packet in your grocery cupboard and you'll see what I mean. When choosing your font, check that it complies. Best way to do...Leave a comment:
-
Just one comment - in my experience, this sort of need is best handled by a custom VBA module with all the necessary SQL built in. It can be a statement created by concatenating strings with parameters such as date ranges and so on to make it flexible to users' specific needs. Relying on queries external to the module simply complicates the debugging process. Assuming the application is running front/back end and the need really is temporary,...Leave a comment:
-
I suggested CorelDraw without registering the need for 30k lines properly. Don't use AutoCad myself, but I have a son who does - his expertise is sea-bed mapping, which poses similar problems. I haven't asked him this specific question, but I know he would support that route. As Adrian says, if the need is just record simple line parameters, a table within Access might be a solution. It depends on what subsequent manipulation is needed.Leave a comment:
-
Your approach also means that your application will not allow multiple records for the same Order/Product combination. Assume this is what you want?Leave a comment:
-
To amplify what Stewart says, you need to remember that a printed bar-code is simply a way of representing an underlying character string (usually a number) with extra characters (checksum digits) to permit verification when read added by the bar-code printing process.
As Stewart says, a bar-code reader connected to a PC and use in an Access application returns the underlying number only - it interprets the bar-code by applying a defined...Leave a comment:
-
I think what you seek to do is really outside Access territory - it just is not good for complicated graphics of any sort. Where my user have needed such reporting I tend to export relevant data to Excel and let the users present in the format they need.
CorelDraw has VBA capability and I wonder whether that might be a more appropriate tool. I've never tried the Corel implementation of VBA, so I can't give any more guidance on precisely...Leave a comment:
-
The simplest way of achieving this is to write a DOS Batch file and run it at scheduled intervals. A batch file is simply a text file which DOS (underlying Windows) interprets.
Here's an example:...Leave a comment:
-
You need to identify the event which starts the process - clicking a control on a form, or whatever. In the VBA code for that event you simply add:
.Code:msgbox("BUSY RUNNING PROCESS")
This will cause a small window to appear, which the user can close by clicking on the OK button. You can make the msgbox function more complex. Try searching the VBA Help file for details.Leave a comment:
-
Nico's advice regarding embedding "-" is good. Access just doesn't like that sort of thing and you get most reliable (and fastest) performance if all object names are restricted to using A-Z (upper and lower case) and 1-9. Using a capital at the start of each word in the name as Nico suggests makes names easier to read.
I'd also be inclined to redesign stWhere so that it doesn't have successive double quotes. I tend to...Leave a comment:
-
I'd agree with NeoPa - you need to sort out the way you are naming objects and then see if your code works. There's lots of help available in this forum and elsewhere on the Internet to help you do this....Leave a comment:
-
Hi, You don't say what is the impact of the other 38 items.
If you want a series of ne records in a single table based on a range of criteria, I think you could achieve what you want by creating one "Make Table" query using one set of criteria and then a whole lot of "Append" queries to deal with all the other criteria. Each query would need to include an extra field which would use iif to set True/False values...Leave a comment:
-
It's quite possible to do all of this in a custom Access database, but I think that for it to work efficiently, you'll end up needing quite extensive coding to build some sort of temporary table with all the generation info. The thought of trying to do this using nested queries just doesn't sound appealing.
As an alternative, why don't you consider using one of the many freeware family tree programs which you can find on the internet?...Leave a comment:
-
I should have added a suggestion to try Alan Brownes website (www.alanbrowne .com) for a series of graded tips, which I've found very useful. They have much relevant to database design, particularly table structure and relationships and the whole issue of data normalization. Preliminary work in these areas will ultimately be worth the effort, I'd say.Leave a comment:
No activity results to display
Leave a comment: