I have a very old program that creates ".dat" files. (I have modified the registry to allow Access to link/import these files)
As long as no one is using these files in the other program I can link/import these into Access with no problem. However if someone is using the .dat file the file is exclusively locked and access won't let me link/import it.
I know you can programatically change the file extention...
racquetballguy
Last Activity: Mar 27 '07, 07:17 PM
Joined: Aug 30 '06
Location:
-
exclusive data locks
-
This should give you what you needCode:Between [forms]![CONSUMIBLES Reportes]![txtFecha1] And [forms]![CONSUMIBLES Reportes]![txtFecha2]
Ivan -
Thanks for your responses
I agreee that "tabledefs" and "refreshlin k" using DAO would have been my first try, but like many others we are migrating away from DAO and using ADO. This is my first try with ADOX.
Unfortunately, my lack of experience with ADOX is showing as I still don't know what is wrong with my code.
Any other ideas would be greatly appreciated.
Thanks...Leave a comment:
-
Unfortunately, this isn't my data design. It comes from a very old program that we hope to get 3 more years use out of but would like to increase the functionality of what we have. Altering the data structure at this time would definately be more trouble than it is worth.
I assume I either need something else in the following part of my code or I have an ommision, I do not know which. Sorry about not using the code tags earlier....Leave a comment:
-
Thanks for all your answers.
Actually the format property of the text box accepted mm/dd/yyyy and let me accomplish what I needed.
For the same project I had another question which I posted under the title "ADOX and linked tables". I will repost that here. Does anyone have any ideas?
And YES, it is 5:00 in the morning and I am working on code, that almost qualifies me as a real programer....Leave a comment:
-
Are you comparing what is entered to 2 seperate parameters "hours" and "combo 12"? Does your user have to enter the text "credit hours - "?
If all they are really entering is a number, just compare it locally for that specific number.
If this is coming from a table that has the text "credit hours - " already there you are better off using a query.
IvanLeave a comment:
-
How about something like
Val(Mid(thestri ng,start position of #,Lenght of #))
If you need to get total length of string for Length of #, you can use Len
IvanLeave a comment:
-
ADOX and linked tables
Hi
I have data tables in the form of
200612...
200701...
200702...
etc
The user specifies the start date and end date in an input form ie: 12/25/2006 - 1/10/2007.
I want to use access to link to the requested tables but maintain the internal structure already set up in access (relationships, queries, reports, etc). The tables being linked to will change frequently.... -
Thanks I didn't realize you could enter mm/dd/yyyy dirctly into the format section of the form.
IvanLeave a comment:
-
Short date problems in a Form
Hi
I have an access form in which dates are entered as short dates with an input mask requiring the entry to be in the form of mm/dd/yyyy. Access automatically changes this for single digit dates/months to m/d/yyyy. Is there any way to force the form to keep the date in the original format entered: ie: "01" as opposed to "1". This data is not saved to a table.
I have looked but cannot find this anywhere.... -
Select top "n" values from a query with a parameter
Hi
I wish to have a user enter a parameter into a form for the number of rows to use to do an average. This form is based upon a query.
SELECT TOP does not support parameters. Something like the top values box in the query page would be ideal.
Is there a way to select only the top "n" values from a query?
Thank You
Ivan -
Hi
I am close, but not quite there yet so let me explain what I am trying to do.
I am trying to create a form where the first 5 fields are user entered and the last 2 fields are calculated while the form is still up - before the user enters the next line of data.
After the last field the user enters I want to use "After Update" to call a query. This query needs to make use of the just entered data and...Leave a comment:
-
Hi
Using recordsetclone didn't help.
In ADO after .MoveLast using:
Me![Something] = rst![somethingelse] returns the last value written to the table.
Me![Something] = [somethingelse] returns the value currently in the form but not yet written to the table.
The problem, I think, is that the sql in the query is based on the TABLE relationships such as the joins. When I run the...Leave a comment:
-
I use the following and have had no problems.
DateDiff("yyyy" ,tbl.DOB,tbl.Da te)+Int(Format( tbl.Date,"mmdd" )<Format(tbl.DO B,"mmdd")) AS Age
IvanLeave a comment:
-
ADO recordsets and Queries
HI
Is there any way while having a data entry form open and using "After Update" to use ADO to open a query that runs the data on the still incomplete open recordset of the form.
rst.MoveLast brings me to the last completed line of data entry, but I want to access the line still being entered.
I can see several work arounds here but I wonder if there is a better way.
Thank You... -
I guess I got hung up on trying to have the query itself have some sort of referential integrity, but what you suggest is much better. Thank you for your help.
IvanLeave a comment:
-
Thank You for your reply
This was first written for only my daughter so the one to many between swimmers and swim team made sense. But now that we have several kids on the team using it you're right, I need a many to many relationship.
Regarding the qualifying times, I have tried the transition table previously and again just now and am able to maintain referential integrity that way. But the problem is that since the...Leave a comment:
-
To clarify:
1. Each swimmer can be on more than one swim team (different seasons).
2. For each swim team, each swimmer will swim many individual races.
3. During a season, each race may be swum multiple times.
4. There is only one qualifying time associated with each individual race.
5. The same qualifying time may be used with each new race.
6. The selection of which qualifying time to use is dependent...Leave a comment:
-
Hi - Thanks for the reply
I had set up a one to many relationship between QTID in tblQualifyingTi mes and the foriegn key of QTID in tblIndividualRa ces. But as the qualifying info is all new, the QTID in tblIndividualRa ces is currently null, and each new entry would be null as the children are entering their race information. I can pick out the correct QTID and times using a query where I have deleted the relationship between QTID in...Leave a comment:
-
Referential Integrity and Indexes
Hi
I have created a database for my kids to keep track of their swim team races. We use this to keep track of their speeds by stroke, fastest times, averages, etc.
I am trying to add a new module, pulled from a form, created from a query, that will calculate if they have qualified for district championships or not. The module works fine, but I cannot write the calculated results back to the table. I think the problem is with...
No activity results to display
Leave a comment: