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
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.
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
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.
I 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.
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.
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...
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.
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...
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
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.
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...
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.
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?
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.
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.
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.
I have a search form built that depending on the dropdown selection on the form, it will run a query to SQL Server 2008 and provide data. There are 5 SQL Server db's so there are 5 different queries. I have each SQL Server linked to the Access DB. When I moved to someones else's computer I got a ODBC Call Failed message. In order to fix this, I had to recreate the links on that person's machine, then change the SQL code in the query with the new name of the linked DB.
I do not have full time internet so I cannot sign in to office 365. I like to know for creating web application locally on my computer what software I have to install and how?There is special procedure for installing software's?
I have a problem with write conflict error. The database is functioning normally and without any problems but on particular computer. the systems are same (windows 7) with office 2010.I have a form with subform based on query. Changing the records in a subform is without any problems, but on one particular computar, I am allways receiving Write conflict error message. When I copy / paste the database from the wrong computer to another one, everything is OK. When I copy / paste it back to problematic computer, the problem is back also.It seems, that the problem is maybe somewhere in settings of this computer.
