I have seen some API that gets the serial of the hard drive, but this information is not unique and changes when the volume is formated.
Does any one know of a way to return the orignal manufucture's information/serial which is unique(GUID) to the volume.
Any Idea will be highly appreciated.
Would having Microsoft Access 2002 and 2003 on my hard drive cause me to have error with my code?
View 4 Replies View RelatedI've saved my Access files (as well as my Word files) to an external hard drive. I can open any Word doc from the hard drive, but when I try to open an Access file, it gives me the following error message: "can't find Language DLL msain.dll". What does that mean, and how can I fix it so that I can open an Access file from the hard drive?
View 1 Replies View RelatedDoes anyone have any experience with placing a multi-user back-end access database on one of these inexpensive "external network hard drives"?
I have a situation where I'd like to share my database with multiple users, but the corporate IM rats have pretty much eliminated all means of allowing us lowly employees of doing that with their network. We have no file server. We do have sharepoint services, but we only have Access 2000, which as far as I know is not capable of exploiting the sharepoint/xml back-end database features. Also, no one in the office here can share a directory on their workstation because they won't grant us administrator priveledges.
So thats how I came upon the idea of buying or creating cheap (<$250 USD) wireless network hard-drive on which to put the back-end. I'm mainly interested in knowing if it will work, and that the performance isn't going to be absolutely pathetic. I'm only looking at having 3 or 4 users at any one time, and the entire database will only house a couple thousand records.
Hello, I was needing some help coming up with the code to search the local hard drive and grab a file and then import it into an Access table. I'm trying to do this on a form if possible. If you know of another way, that would work. Any help would be appreciated. Thanks.
View 9 Replies View RelatedMy workaround was to temporarily map the URL to a vacant drive letter on the local machine, then copy the file over, then drop the mapped drive again. A bit clunky but doesn't incorporate much of a delay and this download only has to happen once per day.
The good news is, the file download / copy now works every time. The bad news is that removing the temporarily mapped drive after the copy has taken place, doesn't and I can't figure out why.
Here are the functions I use to map / unmap the drive :
Code:
Option Compare Database
Option Explicit
Private Const RESOURCETYPE_ANY = &H0&
Private Const CONNECT_UPDATE_PROFILE = &H1&
Private Const RESOURCE_CONNECTED As Long = &H1&
[Code] .....
I have separate functions to check existing drive mappings on the local machine and thus determine an appropriate vacant letter to use for the temporary mapping - they work fine.
Unfortunately the UnMapDrive function returns False (even though I switch the active drive to C: and force the connection to be cancelled with the fForce flag) So the mapping always remains on the users profile.
I don't want to permanently map drives on the users' profiles, just briefly for the purposes of this daily file download.
hi all,
I'm just beginning to know the world of Access so maybe the solution for my problem is pretty simple.
I have a huge database with Itemcodes, Costprice of materials and EffectiveDate (date on which new prices are valid). These dates represent past dates as well as future dates. The one that interests me the most is the most recent date in the past.
What I would need is a query that filters out the most recent date per itemcode because right now there are several prices with several validity dates. Eventually it should result in a database that shows an item with one validitydate and one price.
Right now the same itemcodes are repeated because different validitydates are related to it.
I really hope somebody can help me out on this.
Thanks in advance.
I really have got a mind block!
I am creating a small DB for a vast CD collection and have 3 related tables at present.
I want to have 1 table with the artists, but have it updated when I add a new artist on the main table/form.
So the form does not have the artist. I add that artist, and it is added to the artist table for future use.
Sure I can do this, but cant rememebr how. Please help :)
Jay
My DB has a table named noldba.int_member_history, which contains the following fields:
member_id,
date_start,
date_end,
member_status,
iva_case_id,
case_id,
It is possible for the member to have several lines of data under their same member_id like this:
member_id date_start date_end member_status iva_case_id case_id
20125626 12/1/1990 2/31/1990 N 21116625 20002717C
20125626 1/1/1991 4/30/1992 A 62574431A 20002717C
20125626 5/1/1992 8/31/2000 N 20006625 20002717C
20125626 9/1/2000 12/31/9999 M 21116625 20002717C
20125626 8/1/2000 12/31/9999 M 20111832 20090698C
So this member had 4 start and end dates under case 20002717C
and only 1 start and end date under case 20090698C
I'm trying to write a query which is looking for member_id's along with a case_id which only has one member_status returned from the query and the
member_status must be M. In this case the member has two cases which have the M member_status, but case 20002717C has other types of member status so I would not want the query to return the 20002717C case, only the 20090698C
I'm sure Im asking for something that can't be done...but I'd never know unless I asked. Thanks
I need a query that will return values of a customer number that have been created within the last week.
There is a customer_code field and a date_created field.
Any help would be appreciated.
I want a field in a table that is a date but that is the year only.
I only want this because I want to be able to filter my charts to show one or a span of years for comparison. I have criteria in a query that states between [forms].[charts].[begin] and [forms].[charts].[end] and the corresponding form that my user puts the desired begginning and ending dates into before pressing buttons that bring up the charts based on the query.
My problem is that I can't even get the table to take a year only date. If I leave the date field as text the between clause in the query won't work. I tried it as a number with >= etc. and that didn't work either.
How hard can something this simple be?
Please help me oh cyberspace wizards.
I have created a database in which I have three Fields.
1. Date Joined
2. Renewal Date
3. Member/Renewal
When I type in the date a person joins our club, I have made the renewal date come up displaying a year ahead, when renewal of membershiip is due.
I would like to be able to put in the date joined date and have the field 3 show Member and then when the renewal date is reached, to have in automatically change to Renewal.
It is probaly a simply formula but I can not get it right.
Please Help.
Foxy
Hi,
Currently I have one query that prompts the user for a beginning date, and end date of a week. It then proceeds to show the user all records in that time frame and makes a table. Now I need another query that looks at the dates the user had entered and gets all the records from the week before the user's dates. This query would also be a table query, but separate from the first one.
If anyone at all is able to help me out, I will be deeply impressed and eternally grateful! :)
Thanks,
Chris C.
I want to create a query that extract rows that has a specific word.
i.e.
select * fro table where field like "*ART*"
however it should not retrieve "DART" or "ARTI"
i tried using the following [!a-z] and * like this:
SELECT * from DLs where DLName like "*[!a-z]ART" or DLName like "*[!a-z]ART[!a-z]*" or DLName like "ART[!a-r,s,!t-z]*" or DLName like "ART"
it is very long and complicated - cant i cover it all with one like ?
Also the fact that i also want it to get ARTS (i dont know how to say !a-z expect 's')
Thanx in advance
Hi all!, i would really appriciate it if you could help me out. I have this complex query... in one table i have dates and costs associated that show when fuel was put into the system
such as:
1/1/2008 -- $200
1/20/2008 - $100
1/25/2008 - $150
I then have another table that has data when fuel was taken out of the system
such as:
1/2/2008 -- ($50)
1/3/2008 -- ($20)
1/4/2008 -- ($10)
what i need is a query that is able to show a running tab on the fuel tank and how much fuel is in it...
so for example if it could spit out a result such as
1/1/2008 -- $200
1/2/2008 -- $150
1/3/2008 -- $130
1/4/2008 -- $120
If this is convoluted i can upload a little database..
Thanks! (Here is the current query i am using but its not working right.
SELECT DatePart("yyyy",[purchase_Date]) AS AYear, DatePart("m",[Purchase_Date]) AS AMonth, DatePart("d",[Purchase_Date]) AS ADay, DSum("gallons_purchased","purchase_fuel_tbl","DatePart('d', [purchase_Date])<=" & [ADay] & " And DatePart('m',
[purchase_Date])<=" & [AMonth] & " And DatePart('yyyy',
[purchase_Date])<=" & [AYear] & "") AS RunTot, fuel_use_tbl.fuel_date, fuel_use_tbl.external_ID, fuel_use_tbl.gallons, [RunTot]-[fuel_use_tbl].[gallons] AS cur_Value
FROM (tank_tbl RIGHT JOIN purchase_fuel_tbl ON tank_tbl.tank_ID = purchase_fuel_tbl.tank_ID) LEFT JOIN fuel_use_tbl ON tank_tbl.tank_ID = fuel_use_tbl.tank_ID
GROUP BY DatePart("yyyy",[purchase_Date]), DatePart("m",[Purchase_Date]), DatePart("d",[Purchase_Date]), fuel_use_tbl.fuel_date, fuel_use_tbl.external_ID, fuel_use_tbl.gallons
ORDER BY DatePart("yyyy",[purchase_Date]), DatePart("m",[Purchase_Date]), DatePart("d",[Purchase_Date]);
Having one of those days!!!
I have a simple query populating fields from 2 tables and would like to add a further field to my query (not in tables)
In this field I wish to hard code in 2 values. Can anyone suggest the best way of doing this?
Thanks
Paul
Hey guys,
this may seem unprofessional but anyway..
does anyone know how to DELETE one or more realtionships ?? :o
I have a split database on the network, but I believe it contains hard links (i.e. H:path odb). So, if others use it, if they don't have their H drive mapped the same way I do, they'll get errors. How can I fix this so that it maps to the full path (i.e. \path odb)?
View 1 Replies View RelatedI have something like this
Code:'sets generic workspace Set ws = DBEngine.Workspaces(0) 'sets target database from workspace ******NOTE hardcoded path****** Set db = ws.OpenDatabase("E:Status ReportstatusReport_Test.mdb") 'sets Recordset to deliverablePercentComplete sql statement for target database Set rs1 = db.OpenRecordset(deliverablePercentComplete)
is there a way to replace the path in the set db call, basically it is the current database that is being worked on, thus it is the current database that is opened, is there a way to say something like...
set db = ws.OpenDatabase(currentDB)
Hi
Is any body know how to retrieve the manufacturer's hard disk serial No.? I want to use it in my access application to avoid piracy. At present I am useing a code which gives me Volume serial No., which got changed when ever my user format his hard drive. Instead of HDD firmware serial, code for retrieval of any other permanent No. like mother board or CPU firmware serial can help me to solve my problem
Rahul
I've searched through the forum looking for what i want to do with no luck so hopefully one of you kind people could help.
I'm setting up a DB that logs in a batch of parts to which i generate a batch no.
As the batch progressess through the works when a problem arises we generate fault records (I've set up another table for this and linked the batch no fields together). I want to put a serial no. on this form consisting of 'year' 'batch No.' and ?'Auto number'? From reading posts is it best to put the 3 items in seperate fields (less hassle)
My 2 questions are
1, how do i extract just the year from a date field?
2, This is the main problem. The auto number. If i use auto number to generate a unique number to log the record the number will be massive in no time at all. This is fine as the unique identifier for the record in a table but not for the serial number of the printed report. Idealy I want to have the batch number then a serial number that resets to 1 on a different batch No. For example
21098/1
21098/2 Batch No./serial No.
21098/3
22309/1
22309/2
22309/3
Just some more info this database is a multi user database split front and rear.
I hope i've explained this well enough, many thanks for your help in advance
cheers
EQ
I want a field to be a serial number made up of a letter of the alphabet followed by 3 digits. I want the digits to increase by 1 in each of the following record. For Example the serial number in the first record would be A001, then followed by A002, A003, ....., A142, A143, A144 & so on. I am fairly new at Access but I have experimented with AutoNumber, it won't work if the Field is not a pure mumber, can't get autonumbering to happen if I treat the field as text. I don't know where to go from here.
Any help is much appreciated.
Rob Shakesbeer
I have the following code for the text field (Before Update)
If IsNull(Me![DyNo]) Then
Me![DyNo] = Format(Nz(DMax("[DyNo]", "[tblAllDet]", "[TheYear]='" & Year(Date) & "'"), 0) + 1, "00000")
End If
Me![DyNo] = Format([DyNo], "00000")
The code starts giving numbers from 00001, 00002, 00003 and so on. The problem was that when I have to search, I have to type the zeros before the number i.e. 00007, 00008 etc. otherwise the search form doesn’t show the relevant record. Ideally, I would like the numbering system to be 1, 2, 3, etc. (without the zeros). I tried changing the code to “0” but with the single “0”, I am unable to insert records beyond No.10. Is there a way to change this code so that I get only 1, 2, 3 etc and not with preceding zeros ? Grateful for help.
Hi, I have been trying to make a datbase so I can input the serial number of an electronic device (cell phone boards) , and also would like to be able to add additional info about the device. Most importantly I have to be able to "search" for the device by typing the serial number in a search box.
So lets say I have serial number 11111, 11112, 11113, 11114 listed in the database as "intermittent power failures", before I use the device I can type the serial number in the database and be able to recall the details. So if I type in 11119 and no hits come back, I know that one is not in the system yet; meaning it ethere does not have a problem, or the problem has not been discovered yet. If I type in 111111 for example, it would come back as a hit, saying it has an "intermittent power failure" problem. I have spent about 4 hours messing with access, I used it a while back in office 03, however I have never did anything like that, and to make things further complicated we now only have office 07. Does anyone have a template which is similar (I can modify the values) or know how to assist me to be able to create a database like this?
I'm in the process of streamlining the process to maintain our various access reports and queries.
My company's accounting software stores all record dates in Gregorian Serial format (don't ask me why). Currently for our reports we have a local hard-coded table that is manually updated periodically with dates in MM/DD/YYYY format and the coresponding Gregorian serial date number. To go from date to serial is a fairly straightforward access function of:
(Datediff('d','1/1/2000',[Date to convert])+730120)
For example if [Date to convert] was 2/7/2006 the output would be 732349. That's all well and good, however I am in need of a query I can build that will on the fly generate a list from say 1/1/1997 through 1 year after day being run just to be safe with two columns, one with date and one with the serial date equivelant so I can link to the accounting tables for date restrictions.
This way I just have to have the equation in one query instead of a hard coded table or do the calculation in every form or query that needs to look up these tables.
Unfortuantely I've been staring at accounting data (and am not an accountant) way too long and my brain is fried, suggestions?
Is this possible?
I have a Mitutoyo device that can be connected to a variety of Mitutoyo measuring instruments (in my case, it's a micrometer.) When triggered, the device obtains a measurement value from the instrument. One can view this value via serial communication in a program like HyperTerminal.
Is it possible to input these values directly, or indirectly, into Access?
Thanks ahead.