Updating An Already Installed Db
Oct 8, 2005
Hi,
I have a database that has been in use for sometime but it needs some amendments.
I have burnt the db to cd and plan to make the updates and then take it back and import the tables from the one in use to the newly updated database.
I remember trying this before and it wouldn't let me import the tables as it said they had relationships.
Surely there is an easy way to do this? I don't have to delete the relationships, import the tables and then re-do the relationships?
Many thanks,
Housey
View Replies
ADVERTISEMENT
Mar 14, 2006
Hi,
I have developed a MS Access tool to be used in multiuser environ. In some computers, the tool is working while in some, there is an error message-"Provider not found. May not installed properly". Is it problem with the script or is it that the provider was not installed with MS Office. I have used ADODB connection.
View 1 Replies
View Related
Feb 17, 2008
Ok, I know change isn't always easy, I remember going to 2003 and I didn't think I'd stick with it.
I'm now using 2007 and it's quite different in it's layout. I'm having trouble finding many things that I'm used to having "at my fingertips" but I'm muddling through it. The one thing that I'm totally lost on, has to do with form display.
Have a simple DB that a main form opens on start up. It's relatively small, auto centered, no resize and set to dialog. However, in 2007 it opens up occupying all available workspace space and I have to click the "Size to fit form" button. Then it's not centered.
Where the heck is the flag or setting to tell it to stop doing this?
Secondly, what's everyone else's thoughts on 2007?
View 5 Replies
View Related
Oct 2, 2006
I am building a database for users to input escalations in. The users that are actually keying the information in, do not have MS office. When they try to access the DAP html file, a message appears at the top of the page that states "The page requires the Microsoft Office Web Components.
See the Microsoft Office Web site for more information."
Can data access pages be used without office being installed? I have heard that it could also be the users internet explorer security settings.
Any help would be greatly appreciated.
View 3 Replies
View Related
Nov 22, 2013
We have an access database stored in a shared location. One of the tables in the database is used to record transactions made in an excel spreadsheet-this is done programatically using VBA and SQL.
So here is my silly question; If users don't have access installed locally will the code be able to write to the shared access database?
View 4 Replies
View Related
Aug 16, 2014
I have this VBA code:
Option Compare Database
Option Explicit
Private Const URL_CDOCONFIG As String = ""
Public Function SendEmail(ByVal sTo As String, ByVal sFrom As String, _
Optional ByVal sCC As String = "", Optional ByVal sBCC As String = "", _
Optional ByVal sSubject As String = "", Optional ByVal sBody As String = "", _
[Code] ....
It is being called with the following macro:
SendEmail("gregory.west@dbwsys.mb.ca","vba@dbwsys. mb.ca","","","Subject line","Body of eMail here")
But I get this error message.
The "SendUsing" configuration value is invalid.
View 1 Replies
View Related
Sep 24, 2013
do I need to have MS Access installed, in order to open an ACCDE file.there is no need, as I see ACCDE as an exe file.
View 2 Replies
View Related
Nov 5, 2007
if let say i create a page that have database (*.mdb file) and for my client side, the PC don't have Microsoft Access, can they view the page that have *mdb file?
View 3 Replies
View Related
Jun 24, 2015
How can I list the printers installed on the computer in a listbox? The following code list them in a message box, but I need the user to be able to select one to save it in a table. The listbox is called lstListPrinters and the table tblPrinterSelection
Code:
If Printers.Count > 0 Then
' Get count of installed printers.
strMsg = "Printers installed: " & Printers.Count & vbCrLf & vbCrLf
' Enumerate printer system properties.
For Each prtLoop In Application.Printers
[Code] .....
View 1 Replies
View Related
Mar 24, 2014
My new and previous laptops are both 64 bit and installed MA 2010 on both of the computers running win 8.
When I run reports on my new laptop the reports are not formatting. They are reflecting on 4 pages and not on 1 page like on my previous laptop running the same programs.
On my new laptop I installed Office 2013 and old one office 2010 but I used the same Access 2010 on both laptops which is a separate disk as office was not the professional one.
View 3 Replies
View Related
Jan 22, 2014
I need to give users the ability to change the font of a field in a report. The field shows a barcode.
I thought of using the CommonDlg class to show the Windows font-selecting dialog box, but installed barcode fonts show as a barcode. I need to show the font name.
So I need to populate a combo box with the names of all fonts installed on a computer.
The fonts reside in C:windowsfonts
I have searched Google for a solution but cannot find one.
How do I populate a combo box with the names of all fonts installed on a computer?
View 4 Replies
View Related
Mar 28, 2007
Hi,
I have a database (.mdb file) which includes a table, forms and VB code. I intend on putting it onto a CD and then opening the form on another computer which may not have Access. Is this possible? Can I convert the file or can I attach some type of reader to the disk?
I have seen some software for download on the internet which allows you to open the tables however the Form is the most important thing in this case (but I take it whatever I use, it will need to be able to view the VB, subforms and tables as well since the Form depends on them?).
...also can I install an auto-run to the file for when the disk is inserted? (this is not a major issue though).
Thanks.
View 5 Replies
View Related
Dec 16, 2014
I have a form that has combo boxes and text fields (as well as sub forms). There is also a button linked to some code that says'
Private Sub cmdQuote_Click()
'Creates quote date and prints quote
Me.QuoteDate = Now()
Me.cbAgentID.Requery
DoCmd.OpenReport "Quote", acViewPreview, , "BookingID = " & Me.BookingID
End Sub
When the button is pressed the QuoteDate field (it is bound) should be be populated, but unfortunately it is not. I have played with refresh and requery but cannot derive a solution.
View 1 Replies
View Related
Apr 1, 2005
I have a form with a combo box. If the supplier(s) name is not in the combo box, it asks do you want to add that supplier address? If yes, a popup form displays, where the name and address are entered. THis updates the table. But the problem is the combobox doesn't refresh so the user isn't aware that it has updated.
I've tried updating the form, but that results in the question being asked again, do you want to add that supplier address.
Here is my code
Dim intNewCategory As Integer, intTruncateName As Integer, strTitle As String, intMsgDialog As Integer
' Display message box asking if user wants to add a new category.
strTitle = "Shipper Database"
intMsgDialog = vbYesNo + vbQuestion + vbDefaultButton1
intNewCategory = MsgBox("Do you want to add this Company and Address to the List?", intMsgDialog, strTitle)
If intNewCategory = vbYes Then
' Remove new name from CategoryID combo box so
' control can be requeried when user returns to form.
'DoCmd.RunCommand acCmdUndo
' Display message box and adjust length of value entered in
' CategoryID combo box.
strTitle = "Name Too Long"
intMsgDialog = vbOKOnly + vbExclamation
If Len(NewData) > 50 Then
intTruncateName = MsgBox("Name of the Supplier can be no longer than " _
& "50 characters. The name you entered will be truncated.", _
intMsgDialog, strTitle)
NewData = Left(NewData, 50)
End If
View 1 Replies
View Related
Jun 10, 2006
Hi all
I have a curly problem
A sent a mate a DB a while ago and I want to update it for him... so I need to send him something that will automatically update the forms, queries etc... progamatically i.e without him having to do anything to it.
Ideally, I'd like to front end/back end the DB. But server infrastructure doesn't allow for this. 2 networks are operating and they don't talk cleanly. Essentially, a FE/BE DB will work on one of the networks but not the other. Therefore, the DB is one whole DB so that BE tables don't need refreshing.
The way I see it... I have 2 options. Or maybe there are other options??
1. Export forms, queries etc... to the old DB or
2. Import the data tables into the new one.
At this stage I prefer option 2.
I have some idea how do this this but would appreciate some advice. Ideally, I'd like the user to click an update button to import tables, delete the old DB and transfer the new DB into the appropriate folder (and maybe rename the DB if it needs it??)
Any help appreciated.
View 2 Replies
View Related
Dec 29, 2007
I want to make an update code without referring to the form
My update query reads in is sql as follows
Dim SQL As String
StrSQL = "UPDATE products SET products.new = [products].[grossprice]-[products].[grossprice]*28/100"
I want to rewrite it in the following way :
Dim Diff As String
Diff = [products].[grossprice] - [products].[grossprice]
SQL = "UPDATE products SET products.new = diff*28/100 "
However this effort fails since i have to refer to a form.Can i build a code without referring to a form?
View 2 Replies
View Related
Mar 31, 2006
I have a database with details about employees in it.
There is a field with yearly salary in it and another with an ID number. Recently these slaaries have been increased by a non-standard amount. I have another table with the emplyee ID number and their new salary. I need to update the slaary figure in the first table with the salary figure in the second table. Is there anyway of doing this?
Any help would be most appreciated
Nick:)
View 3 Replies
View Related
May 1, 2006
I need to be able to update all the date records in a table using an update query. Any ideas of what i have to put in the 'update to' box to get all the dates to change from dd/mm/2005 to be dd/mm/2006
cheers for any help
View 1 Replies
View Related
Sep 27, 2006
Hi there people...i'm doing a databae project for A2 level coursework and have encountered a problem..please help me if you can.
I have a table of names. Also another table (actions) which contains several fields, but 2 of them are names, (1 being Proposer, and other being Actionee), are obtained from the names table.
However, when altering for instance the spelling of one of the names in the names table it does not update the spelling in the actions table. i have tried using the relationship-update option but this doesn't work because the names appear more than once in the actions table. if it were to appear just the once in the actions table then i wouldn't have any problem. but it is a requirement that the 2 names fields are in the actions table.
Any ideas of how to solve this?
View 9 Replies
View Related
Nov 6, 2006
can someone tell me how to make a form's data change when related data is changed in another form. E.g. If I change the price of a product in 'products' to £3.00, how do I make it automatically show that it is £3.00 in 'orders' just by typing in the product code?
View 1 Replies
View Related
Aug 29, 2007
hi everyone,
I have a "subformB" wich is inside a "MainForm". When "MainForm" loads up (and therefore subformB loads as well), "subformB" does not show the results it is supposed to show until I click on it. It doesn't update itself 'till I click on it. Can anyone give me a hand on this?
Thank you very much
View 5 Replies
View Related
Feb 24, 2005
I have used a make table query to create a table with text values. I need to convert these values to numerical data, for instance "Male" should become 1 and "Female" should become 0. I tried doing this in an update query, but had to use 2 separate queries. Don't know if a macro would work to update a table (there are no forms in this DB, it's all data fields). Same with code, I usually do this with forms. How can I update the raw data, which in some cases has multiple ifs, into the correct format? Thanks!
View 4 Replies
View Related
Oct 15, 2005
i have 4 tables in access and i need to be able to add information in one table and it to appear in the other 3 without me having to go in to each individual table and enter it.
Is this possible?
View 1 Replies
View Related
Mar 10, 2006
I have two tables. One table is linked to a text file that is always update by the another program. I have another table the is same exact one but it does not get updated.
I have access run these two tables to see the difference between. (Its basically and add/drop function) But after I run those two tables to see the difference, I want to update the nonlink file, so it is up to date with the "link" table. Thank you.
View 3 Replies
View Related
May 18, 2007
Good morning, I'm a newbie....and I inherited this db.
I have an existing table. I need to add two rows of information. When I add the rows, they are empty. I have tried running a query with all the fields from the table plus the two rows I need, but I loose 90+ records. What am I doing wrong???
Thank you for any help...
View 12 Replies
View Related
Feb 2, 2008
Here's my problem:
I have a table called WorkOrder. I have fields labeled:
JobID, which is an autonumber
WODate, which is formatted as =Date()
and WOID, long integer
Here's what I want to do and have done:
On my form I have WOID control source set to:
=Format([WODate],"mmddyy") & Format([JobID],"00")
I know that storing calculated values isn't the preferred method but it's what I've done.
The problem is I have a cmd button on the form, that when clicked asked for the WOID. This button is based on a query to print a specific work order.
The problems is that this calculated value (WOID) isn't appended to the table so nothing exists when the cmd button is click and the WOID is entered.
How can I update the table with this WOID for the specific job?
View 1 Replies
View Related
