Hi,
just starting out building a database product for mineral collectors and wanted to know what to do went it is complete.
If you want to issue the finished collectors data base as an application to other users do you need a program generator?
I have heard o the Access tollbox, does this do carry out the generation?
Thanks
I am trying to upscale several databases from mdb to sql server. Unfortunately I am not sure of all the programs that use these database tables. Is there a way for the mdb to store what programs request data from it or alternatively the username. Im thinking not but worth a check.
View 2 Replies View RelatedI want to publish my access database on my local pc and was thinking of using something like Dreamweaver to do this. Is this possible? I don't want to put this on the webserver but on my local machine (only a few people will be connecting), and I've read something about a Personal Web Server so this could be done. Does anyone have any ideas / thoughts on the best way to do this? Oh, I want the database / web to be "live" so the tables get updated as they are changed over the web.
View 3 Replies View RelatedI have small program in access database which contains about 100 cca tables, querys, forms, macros in total. Customer which both program from me, wants me to enable him to access this program not just from work, it wants to access it from home or when he is on business trip from hotel etc.
I am little confused how to achieve this and what are my options? I assume I have to set by database somewhere on server and so my customer could access it any time? Do I have to upsize access database to SQL express or similar?
Also, one more important question: is it possible to "convert" access database into HTML code or similar so it could be accessed via web browser without need to install microsoft access and with freedom that it can be opened from any type of PC OS (Linux, Mac etc)?
My office recently purchased Microsoft Access for our secretary to keep track of our contacts. No other employee owns Access so we have to distribute the tables through Access Runtime. However, there seems to be a problem.
I save and publish a database using the Packaging Wizard. I then send the associated folder with the install program to a computer which has Access Runtime installed on it. But, when I install the file I created with Packaging Wizard it just opens an Access window that is completely blank. It's actually the same thing that occurs when I try to open an Access file on a computer that doesn't have Access or Runtime installed on it at all.
Hi all,
It's my 1st posting! Need help on how to get Unbound OLE objects (i.e. lines, pics, et.) reflected when publishing my Access report into MS Word. So far, only the data are exported. Appreciate your help.
System Info: Intel Celeron 700MHz, W98SE, MS Access 2002
Having experimented with Access for a few months now; I know you can link an Access Database to SharePoint, and you can export Excel files into Access for inclusion in tables.
My question is; If I have a daily report being produced, through script, with an excel output. Is there anyway to automatically publish this in Access, negating the need to manually go into Access to import?
I am hoping someone can give me guidance on a fairly major project I am working on.
I am responsible for producing lots of figures, charts etc. each month and the current process takes a very long time!
I have been charged with improving this process, which currently includes the following:-
Slightly changing some CSV files each month
Importing the CSV files to an Access database containing lots of other data and information
Running some queries off an SQL database and importing the results to the access database
Running a few queries in Access
Exporting the query results to Excel
Manual manipulation of the Excle files
Producing graphs and tables in excel
I am fairly experienced in Access and know a little Access VBA
I know a bit of SQL to run queries from SQL query analyzer
I have dabbled with VBA in excel
But I wouldn't really call myself a programmer
I need to automate the process as much as possible, but I am not sure which way to go. I would need a database to combine the data from CSV files and other information as current, but also need to build up a historical store of data.
I would then want some kind of front end to select the months and year to look at, plus different categories etc. then produce a table and chart to excel or easily exported to excel for distribution to other people.
Would a combination of Access and Excel using VBA be sufficient for this?
A colleague has mentioned using SQL, in particular MySQL, which is downloadable for free.
They have also said that you can develop a front end in visual basic and there are programs freely available where you can build a visual basic front end by drag and drop methods.
They also mentioned that you could build a front end using Java.
I have also read bits on this site about ASP and PHP and how they can be used as a front end with Access as a back end database.
In short, I am getting confused about which combination of tools would be best suited for this job!
Any assistant/opinions/thoughts would be greatly appreciated!
The output tables/charts etc. would have to be distrubuted to a large range of people in the company.
The database or front end would just be viewed by a couple of people.
Many thanks!
Sasha
I'm having an issue with two programs. One searches the DB and emails the results, the other searches the DBand prints labels from a report. When only one is in there the program will run fine. But when I try to implementboth at once then I get an error message that is something like: The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected: SQLSafeThe way the form is setup I am using the same text box to enter my search criteria and the same option groupbox with my check boxes for what I'm searching for both programs. Is this possibly the conflict? Am I going to haveto have seperate option groups and search criteria boxes for each program? It would be nice if I don't because thiskeeps the look of my form clean. Thoughts?Code for Search Database and Send Email
Code:'Designed by M. Walts'Important information! this code requires a reference to the Microsoft DAO object libraryOption Compare DatabaseOption ExplicitPrivate Sub cmdEmail_Click()'will hold the dynamic SQL queryDim strSQL As String'will hold the WHERE clause portion of our SQL queryDim strWHERE As String'will hold all the recipients of this messageDim strRecipients As String'the recordset we will use to get the emails of the records that match our criteriaDim rst As DAO.Recordset'if there is input in the search criteria, then we will run the query and send the e-mailIf txtSearch <> "" Then'if you have more buttons, just add mosr cases (the value of the radio button'= the Case number, so Value of the State radio button is 1, etc.)Select Case opgSearch.ValueCase 1strWHERE = "WHERE State = '" & txtSearch & "'"Case 2strWHERE = "WHERE City = '" & txtSearch & "'" End SelectstrSQL = "SELECT EMail FROM tblUser " & strWHERE'run the query and get the results into the recordsetSet rst = CurrentDb.OpenRecordset(strSQL)'Loop through the recordset and add all the EMailsDo While Not rst.EOFstrRecipients = strRecipients & ";" & rst!EMailrst.MoveNextLoop'remove the first ; from the strRecipientsstrRecipients = Right(strRecipients, Len(strRecipients) - 1)MsgBox strRecipientsDoCmd.SendObject , , , , , strRecipients, txtSubject, txtBody, Falserst.CloseSet rst = NothingEnd IfEnd Sub'stops a ' entered in the field from breaking the queryPrivate Function SQLSafe(safeMe As String) As StringSQLSafe = Replace(safeMe, "'", "''")End FunctionCode for Search Database and Print LabelsCode:Private Sub printLabels_Click()'Edited by Nicholas Brown, original code design by M. Walts'Important information! this code requires a reference to the Microsoft DAO object library'will hold the dynamic SQL queryDim strSQL As String'will hold the WHERE clause portion of our SQL queryDim strWHERE As String'will hold all the recipients of this messageDim strRecipients As String'the recordset we will use to get the emails of the records that match our criteriaDim rst As DAO.Recordset'if there is input in the search criteria, then we will run the query and send the e-mailIf txtSearch <> "" Then'if you have more buttons, just add mosr cases (the value of the radio button'= the Case number, so Value of the State radio button is 1, etc.)Select Case opgSearch.ValueCase 1strWHERE = "WHERE State = '" & txtSearch & "'"Case 2strWHERE = "WHERE City = '" & txtSearch & "'"End Select DoCmd.SetWarnings False DoCmd.DeleteObject acTable, "tmpClients" strSQL = "SELECT tblUser.* INTO tmpClients FROM tblUser " & strWHERE DoCmd.RunSQL strSQL DoCmd.OpenReport "Labels", acViewPreview 'just view for testing, switch to print mode later acViewNormal DoCmd.SetWarnings TrueSet rst = NothingEnd IfEnd Sub'stops a ' entered in the field from breaking the queryPrivate Function SQLSafe(safeMe As String) As StringSQLSafe = Replace(safeMe, "'", "''")End Function
Hi All,
I need some advice as to what is the best way for me to update a program in 3 different locations.
I have developed a program that I now have running in 3 separate locations. Each location uses the same program structure and tables, but they will have different data.
When I make a change to the one in our office, I would like to update the other 2 offices so that we all are using the latest version.
CURRENTLY: I make a database file with the “forms, Reports, Queries, and modules” necessary to accommodate the changes. Then I, email the file to the other offices. I then try to walk someone there at the office through; “Get Files: Import”, then delete the old files and rename the new ones. This is risky!!!!!:(
I know there is a better way of doing this, I just don’t know it.
Can some one help me on this issue?
Thanks for all your help….ENVIVA :)
I have a query called "Program Status Count" that keeps track of the current status of various programs. There are three statuses: Closed, Deficient, and WIP.On the Query, I used "Total:" row and have two fields: StatusID field set to "Group By" then in the next column I have the same StatusID Field set to "Count" (it auto-renamed itself to CountofStatusID)...which on the query does what it is supposed to do:
Closed, 2
Deficient, 1
WIP, 1
When I go to the Report Design and try to make a Pie Chart (or any graph) it asks me what query I want to use, so I point it to the Program Status Count Query and select the only two fields I have in the query.This is the Row Source Code:
SELECT [StatusID],Count([StatusID]) AS [CountOfStatusID] FROM [Program Status Count] GROUP BY [StatusID];
Sometimes, it will show the appropriate fields but then it will disappear in Report View, switching to Print Preview does not fix the issue. Actually, it often deletes the correct information in the chart and use the PK autonumber instead of the words.Othertimes, the default data shows up and nothing I do changes it. I have even done the copy/paste of the query table in the report (doesn't work when the graph needs to update.
Hi folks,
I'm new to the business of publishing a database on the net... though I have some experience with HTML and XML, I have absolutely no knowledge of ASP at all. I wonder if anyone would be kind enough to walk me through the steps of getting my database up and operational on the web. Thank you in advance!
~Lana Faith Call
Hi
Has anyone ever got this error message before? I’ve never came across it and I don’t know how to fix it. The error message displayed when I added three extra labels to a form then tried running it. At the beginning, it took more time than usual to think about it then the error message was displayed. Now I can’t open my form in design view nor can I run it! It’s totally inaccessible.
The error msg is attached.
Any help will be very much appreciated,
B
How do I Pubish a from from access into word using a word template i have created? and not just into a blank word document?
View 1 Replies View RelatedHello. This is my first post so be kind!
Im currently working on a project which involves taking customers data via MS ACCESS and storing it in a database. Which has in iternet connection. I would like stored data to be available online.
Which would be the best way to go about this?
MYSQL?
Just a little confused.
Also had a quick browse round the forum and looks like i might be spending a lot of time here:D
Brain-death is a horrible thing to witness.
I have searched FAQs, advanced search, etc., and know I'm not looking in the right places.
Question: How do you, in this forum, publish a URL using a descriptive title versus the actual URL itself?
Obviously it's not rocket-science since so many contributors do it apparently effortlessly, but folks I'm struggling.
Please point me in the right direction.
Thanks - Bob
Maybe this shouldnt even be done in a form as simple of a task i need. I have a query of multiple tables andi want to be able to export it to word with only a few of the columns from the query as well as displayings yes/no instead of -1/0. Basically im just trying to make a table in word so i can have all the correct pages headers and such to make our document control people happy.
Is there a way to publish a form to a word document and get the header of each column to appear at the top of each page? I noticed that if i export the form to HTML then copy and paste the table in the html file to word its works but thats a huge pain in the you know what, and the table ends up looking a bit odd in word and no amount of table formatting seems to fix that but thats a different issue.
Thanks
I am trying to add to a db I inherited. One of the end reports that is produced is a cost breakdown for each end user.As things stand, the data collates into individual reports which are then grouped into one file and saved via PDF. What I am trying to work out is whether or not I can selectively pick some of those reports to have more than one copy.
I see a form (within an existing form) that will list all of the end users for a particular scheme and, next to that, be a dropdown that will allow the db user to select how many copies of each report needs to be published. These will then collate merrily into one document to be saved to PDF.
Hello,
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.
How can I do to solve this?
Thanks.
Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!
Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.
Regards,
Kishore
Using Access's User and Group Accounts or Using a Login Form to access database?
I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.
I also saw some sites where they give an example of a Login Form and how to create one.
My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?
But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?
Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.
How would I go about creating that. Hope I made my explanation clear.
Thanks in advance.
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
I have a simple access search form , that's based on a query that fill parameters from the form textboxes, when the access form loads its keeps prompting for parameters value which looks ugly .. I want to open the form, displaying all the records in the table and filter when i click search ..
I have a data entry entry form, that i want to generate success message after successful insert in database. I have done it in the button event if no error happens, still if i left all fields blank and clicked save, it displays the message ..
I need to change that to display please fill the textboxes then click save , and display success message when the row is actually inserted ..
Check the following attachment for sample.
I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:
My code is:
On Error GoTo Err_Command151_Click
' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String
[Code] .....
The syntax error I get in Access 2010 is:
Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'
Attached is a screenshot of the relationships in a database I built a couple of years ago. It's worked absolutely fine in Access 2003 and currently has over 18,000 customers with associated information in it.
However, when I open the database in Access 2007 the performance is awful. All the forms are very slow to respond when tabbing between form elements. I've experimented by reducing the number of form elements calling on related data on a given page and whilst this improves performance it reduces usability - something I don't want to compromise on especially since Access 2007 should be able to cope with this.
My next question is therefore whether I've got the most efficient underlying table design and I can't see any other way of doing it than my current method so I'd be grateful for any feedback or advice anyone has.