I am building a database of all the computers at the company i work for. Each computer has a unique ID. I want to be able to enter the ID of a computer and have its details displayed. IE. A user enters 34321 and then computer 34321 shows up and has information about its history specification etc.
Where do i start?
I have a database built using Microsoft Access 97-SR2. I want to copy it to another computer (my office computer). I was successful in burning the file to a CD-R disc. However, when I run the database from the disc, a message appears saying its READ ONLY-it apparently makes it Read Only automatically. I want to be able to change and edit the data and the controls, ie. forms, reports, etc. on the other computer. How can I transfer the database my other computer, without it becoming Read Only?
Any help would be appreciated
Urbaud
"The key or key combination ^{Break} in FunctionKey_SubForm has invalid syntax or is not allowed"
- -
The "FunctionKey_SubForm" is a macro in this database.
It only does it on my computer when I opens this specific database.
This database works fine (copied it elsewhere) on everyone elses computer and also when I use it one another computer, whether the database is on the server or on the C: drive.
Since it works fine on all other computers, it's a setting in Access which is throwing up the error (even if it is " invalid syntax or is not allowed"), not the database.
Database works fine after I click through it but it's irritating and I don't recall changing anything.
I'm using Access 2007 which I built a database that runs queries off of tables using ODBC. The database is all done in ms access, I've used no visual basic programing on it. I'm now trying to move a copy of the database to another computer's local drive in the office. When we try to open it on the other computer it gives me an error that says "There was a problem sending the command to the program" and Access hangs, which I then have to run task manager to end the program.
Specs Are: Windows 7 64bit (the db was created on Windows 7 32bit)
Microsoft Access Version 2007
And yes I now that's the title of a Knowledge base article, I stole it because it put into words what I can only say in expletives right now.
Basically, well it's all a bit odd.
I got users on the network who, until yesterday, could access some networked databases. Other files from the same source are ok, just Access files.
Today the moment they click (and I mean a single-click) on the icon to open the database...explorer hangs.
You can't open the database from within MS Access either, that hangs too. But you CAN open them up and use them if you can get them copied locally.
Oh yeah, some people (in the same room, on the same VLAN) can access the database, but can't perform any tasks within it.
Databases are a mix of 97 and 2000.
And to make matters worse, it's happening on another server.
I know you're gonna shout virus, but that looks to be a non-starter since I know of no such virus which would affect ONLY Access files and do it on a single click, and secondly The systems check out fine with both Sophos (and our good luck charm AVG) run against them.
Holy Moley! Has anyone ever come accross such a palarva?
Moving to new computer, both under Win XP pro, Access 2003. New computer is MacBook Air running Parallels. Transferred Access database via an external hard drive. Now the data shows up as Read Only. Is there a procedure to run down the cause and make the data accessible?
View 3 Replies View RelatedAnyone know how to get the computer ID or name unique to your computer?
I want to be able to use it in a database to keep logs for each computer on the network.
Any ideas?
Hi
I don't know ASP at all, and I know very little about the Internet.I do know JavaScript and VB6 among other things, so I am not a complete dummy.
I have a webpage on a webhosting company's ftp (they host asp) and my html file is working, but my asp file won't do anything (should I be calling it with the javascript from my html file?).
What I want to do is make a list of the top 10 players of a game.
My questions:
1. how do i get my asp to display anything?
If I use my winXP IIS I can view ASP files. But from this ftp the computer just asks me if I want to run the file or save it and then opens my interdev program. Please help before I throw this computer out the window and I don't get to see your message.
2. Should my access file be 2.0 or 7.0 or whichever?
3. I use this code (from a tutorial) to connect to a database,
but it doesn't work.
[code]
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>
What is DSNname?(In VB6 it is the name of the data control), but there is no such thing here, is it the mdb file name?
I think I will have many more questions but for now I'll stop here.
Thanks
After 2 days of searching I am sick too my stomach from not finding what I needed. I simply do not understand how it is possible that everyone, including Microsoft, assumes people just know stuff.
I have been wanted to read text files within an Access DB. The DB will extract key words and store them into fields. This is all very simple if I could get the rotten VB to read the files. I wanted to use the object My.Computer.FIlesystem, and all the others associated with that library. But going through the hundreds of possible references, I haven't a clue to which one has that library.
No matter where I went too look, not a single line, post, page listed how to reference it. Only how to use the function. So frustration.
My current reference list is as follows:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DOA 3.6 Object Library
Microsoft ActiveX Data Object 2.5 Library
If someone can please help.
Can anyone help i was in a database and my computer crashed now when i try to load the database it says it needs to be repaired so i click yes to repair it and it comes up Could not find Description how can i fix this
View 2 Replies View RelatedI want to transfer and old database used currently for quotes etc to a new computer. I transfered all files, but when I want to open the file an error message comes up referring to the old location on a small office network. How can I import, that is use the files on new computers??
Thanks! You help is greatly appreciated!
Deed, Auckland, NZ
I have a small lookup app working fine on one computer. When I copy the files to another computer, it does not recognize the search entry as having a value.
What have I missed doing?
Thanks
Hi,
I made one database. Inside the database, I want to make a screen that show that which computer is in use of the current database.
Can we do that? Does anybody know how to do?
Thanks.
Hi,
My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful,
Thank-you for your help in advance, and i apologise for such a lengthy post!
Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here.
Chris
I am trying to create an Access database that can be used to configure computers for sale in a small pc repair shop.
What i need it to do is have drop down boxes for different parts, each part having a value, and at the end being able to update the total value depending on which parts are selected.
I have tables with different types of CPUs, Motherboards, RAM, etc etc... each table has description and price values ( a couple more for relational stuff but i don't think that is needed to figure this out ) Just to test it out i have a form where i can go through and select the different products, but i am stuck on the adding of values of the different computer parts.
So anyway, i am trying to take prices matched with values from multiple tables, then add the prices all together at the end for a total value, like any of the pc configurators online.
If anyone can help, greatly appreciated, if i make no sense just ask to clarify...
james
In my Frontend, i use parameters like:
1) computer name
2) a certain file's existance
So i'm sure that the front end is being run on an autherized computer.
i have hardcoded these values in the vb code and password protected the project so that no one knows about it.
what other parameters can i use to stop the front end being run from any other computer else than thoses allowed.
Hello,
For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.
Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in :confused:
Any other comments or suggestions are welcome too if there is a better way of doing this.
Thanks, ieuuk
How would I get Access to autopopulate a table's text field with the user's computer name when they enter data into a form? The user shouldn't have to enter this...
View 4 Replies View RelatedHi -
I have a form used to enter criteria for display of records on a subform. There is a refresh procedure that is used to update the subform. This procedure is called on load as well as after changing any of the criteria.
This has worked fine on multiple computers running both Access 02 and 03. However, one of my clients has a machine that seems to choke on this procedure. I get the following error message -
"2455: You entered an expression that has an invalid reference to the property Form/Report"
The procedure called is:
Private Sub RefreshSubform()
Dim strSQL As String
strSQL = "SELECT * FROM qryProjectsCases"
If Not (IsNull(BuildFilter)) Then
strSQL = strSQL & " WHERE " & BuildFilter
End If
' Me.frmsubProjCases.Form.RecordSource = strSQL
' Me.frmsubProjCases.Form.Requery
Forms!frmCaseList!frmsubProjCases.Form.RecordSourc e = strSQL
Forms!frmCaseList!frmsubProjCases.Form.Requery
End Sub
The error occurs at the line where I try to set the record source property for the subform. Note there are two commented lines, this was the original code and experienced the same error. Both methods of referencing the form generate the same error (on this one particular machine - both work on the other machines).
The function BuildFilter generates a SQL string based on the various criteria on the main form. I have even tried setting SQL to a constant, but still get the error.
I have checked to see if the References are complete, but don't find any missing.
Any suggestions?
- g
The problem I having is if I have a computer name of a computer on our network (not the one I am running the database on), is there a way using VBa to find the details about this machine.
For example if the computer name is 'DTP002133' I can click 'start' then 'search for files and folders' then click 'computers' in the search for other items. This search will give me the computer location and comments. I would like to be able to automate this process within my database.
Not sure if this one is possible but thought I'd pick you brains...
Thanks
I have a split database (A2000) on a server; many people use the database at many different terminals. I would like to save the computers identification to the record being created. Any ideas on how to accomplish this?
Thanks
gMAC
Right now i using client server application using
- Frond End : Ms.Access + Winsock with UDP protocol. ( This program like Yahoo Messenger )
- Back End : Sql Server
I made this program for Remote Trading.
every second server or client will be send data.
Sometime Server send data only to specific client, so when client logon to application, I save the IP number and after logout i clear the IP
the problem will be happen when the computer client Hang, server cannt send a data to that computer, and waiting for ever until server hang too after that all client will be hang.
and the question is How to check status computer already ON or Off
i mean before server send data, server will be check status computer with that IP, If status computer On then True else False, so if computer client off, server don't need to send data.
thx
Erwin
I have hyperlinks from within Access forms that link to Adobe PDF documents; these are the new PDF Package documents created with Acrobat 8 - and give the message "Multiple files are bound together in this PDF Package."
The problem I am having is that when ever I click on the hyperlink the computer hangs (from the task manager, I believe that it is Acrobat Reader that is hanging). This problem only occurs with multi-file PDF packages and does not occur with regular PDF's. It also only occur with MS Access, as linking to theses files from MS Word encounters no problems.
Is anyone aware of a fix for this?
Anyone know of a way in Access/VB to determine what the region/location is set to on a user's computer? Need to determine whether to use commas or decimals as a monetary separator.
Thanks,
B
I have been searching and found a few great threads about checking users but the codes there were incomplete. Is there a way to effectively log a user's name & computer name when they open your database and also log when they close/exit your database. Without them noticing but just for your own personal security incase something happens and you would like to know who all was actually working in/on the database at that specific time?
Or just something that will show me who is in the database so I dont' have to keep seeing network333 something has it open.
Thanking you all in advance, and I know I am a P.I.T.A.!
I have been using a second, larger monitor, hooked up to my laptop so I can use the "extend" function of my laptop and work on multiple programs on two different screens. Until today, I never had a problem with this setup and Access. I would hit a button I had created and the resulting screen would stay in the same window as the Access program.
When I open the program on my laptop computer screen, it opens to a main form with a sub form (see mainform.jpg). When I click on a number below "Click 4 Product Frm" box in the subform (for example "179"), the Products form pops up (product_pop-up.jpg), on the SAME laptop screen the main form was shown on.
The problem arises when I click on the Accessories button in the right middle portion of the Products form. The resultant Accessories form (access-pop-up.jpg). This screen always pops open on the second (or extended) screen. I can drag the form back over to the laptop screen, but if I click on the Accessories tab again, it still opens on the extended screen. To make matters worse, if I am not connected to a 2nd screen, the Accessories form can not be seen on the laptop as it is trying to open on the extended screen that is not there.