From Work To Home Can't Open Access
Jun 4, 2005
Hi,
I had copied my MS Access database that I made from work and tried to open it from my home to work. And it said it is only Read_Only. Why is that? Can I change this from my home PC or Can I work with this only from work?
Another thing, then I tried to create another database and I could only do this by creating table from design view and entering data. But I was not able to create it using the table wizard. When I click on the table wizard, nothing happens.
My work's MS Access is 2000 professional version I think, and my home MS Access is 2000l.
Could someone give some advice???
thank you,
Carboncopy
View Replies
ADVERTISEMENT
Jun 16, 2013
i have created a login form that opens the home page when the correct credentials are entered. i would like to add an 'access level' so that when logging in the database checks the access level and opens the appropriate home page. (i.e. level one has selected options.. level three has admin)
i just need a code that checks what the users level is and then open home lvl#
(i.e. user level 1 - open 'home lvl1', user level 2 - open 'home lvl2 etc)...
View 5 Replies
View Related
Oct 18, 2014
I use below simple command line to start a macro in my Access database. Usually all works well. I start my bat file, command is executed and macro does its job.
However it always fails if I have a session of Access already opened even if it is a completely different database. If I use below then it opens another sessions of Access but does not execute the macro. I need to go into the second session and run macro manually. It works fine then.
Code:
"C:UsersMeDocumentsDatabas1.accdb" /X Macro
View 1 Replies
View Related
Oct 7, 2007
hi there,
i'm thinking about upgrading my operating system from XP to Vista Home Basic, but curious if any users have have experianced any dramas running Access 2003 SP3 on the Vista platform? or shouldnt there be any mayjor problems.
regards
Colin
View 2 Replies
View Related
Sep 25, 2013
I have a database with a Supply Receipt Form. The first field in the form is a combobox for the user to select a material/supply. I'd like for the form to open to a new record every time. When I use:
DoCmd.GoToRecord , , acNewRec
in the Form On Open property, I lose the ability to select the material/supply. Same thing happens when I set the Data Entry property to Yes.
View 3 Replies
View Related
Jun 25, 2013
I have tried a few times to get open args to work while opening a new form.I never could get it to work.
View 4 Replies
View Related
Sep 17, 2013
I am extremely new to writing code, but was able to successfully write code that transfers the data in my form to and excel spreadsheet template and saves it with a different name. The code works perfect and without issue as long as Excel is not running. However if Excel is already open the template remains blank and a warning message appears saying that the form is locked for editing. Below is the code I used.
Private Sub ExcelClear_Click()
Dim xlApp As Excel.Application
Dim xlwrkBk As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = New Excel.Application
[Code] .....
View 2 Replies
View Related
Aug 25, 2014
Windows 7
Access 2013
I've been trying to work up a where clause that is generated by a button click event on a report. The workflow that i'm trying to obtain is as follows:
1) A report is run to determine the remaining work orders that need to be processed.
2) A button that is placed on that report is to be clicked, taking the user to the form associated with that work order, so it can be processed.
What i've been able to do so far is capture the unique ID for the work order and then print that in a message box. I can then open the form.
What i haven't been able to accomplish thus far is to open the form to the correct work order.
Things I've tried : I started trying to use the macro with the search for record option and using the where clause. Not successful. I am a little more comfortable in using vba so i switched to that pretty quickly.
Code:
Private Sub btnJobEntry_Click()
'GOAL: open the work order form to the correct entry
'METHOD: store the uniqueID to a variable, then use that in the open command's where clause
Dim strJobID As String
'store the unique ID in the variable
[Code] ....
I've put the strJobID variable in both the filter and where clause sections of the DoCmd but it just opens the form to the first entry. I'm fairly confident i'm not applying the filter/where clause correctly by using the incorrect syntax.
View 3 Replies
View Related
Sep 9, 2011
I'm getting ready to deploy my database and I would like to Hide the "Home" tab and replace it with a custom tab with just the bare minimum of options. I have alreadyused the access options to hide the other tabs that re normally visible, but can't find how to hide the "Home" tab.
View 1 Replies
View Related
Feb 10, 2014
I am in Microsoft 2013 and using an .accde file. The problem is that the File menu and Home ribbon are still accessible, and the File menu can be used to change settings that will let the user get into the linked tables (on SQL Server).
View 2 Replies
View Related
Jul 23, 2014
I have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page.
Is it at all possible to disable the main access page for the user?
If not, is it at all possible to set a logout macro to the X button on the main page?
If not, is it at all possible to set a logout macro to activate on "Quit Access"?
View 4 Replies
View Related
Jan 20, 2014
I am currently developing a database to provide a friend with an auction tracking and ordering system.
I will have a number of questions the first is related to the Home Page/Dashboard/Summary form I am creating. I basically have a few sections, one of which is a combo box offering the user to select an auction to view in the summary section. This summary section contains the list of lots but I also hope to to expand on this and create multiple text boxes, each containing the answer to a number of queries (totals etc).
I have written all the queries and can see the results however as the form does not have a record source I would like to know how to make each text box populate with the result of different queries (ideally in vb - I am using ms access 2010)?
I have tried a few things, control source doesn't apply as I have no record source (i guess). I investigated Dlookup/Dcount but am unsure if these apply for the same reason. I understand I am likely to need a recordset etc in vb and have already tried a few things but unfortunately none of them work.
View 1 Replies
View Related
Jul 13, 2005
I have an application on access that export the data to word.
I did a query and the data export to word
my code is:
Dim db, rst
Dim strSQL As String
Set db = CurrentDb
'÷éùåø åôúéçú ååøã, åäöâúå áöåøä îåñøú
Dim objWord 'As Word.Application
'Set word as an application and make it invisible
Set objWord = CreateObject("Word.Application")
objWord.Visible = False 'True is visible
'ùí äîñîê
objWord.Documents.Add ("C:doc3.doc")
strSQL = Me.strSQL
Set rst = db.OpenRecordset(strSQL)
rst.MoveFirst
Dim strString As String
strString = ""
Do While Not rst.EOF
'ID---------------------------------
strString = strString & rst!nameID & vbTab & vbTab & "|"
'name-------------------------------
If Not IsNull(rst!fName) Then
strString = strString & rst!fName & vbTab & vbTab & "|"
End If
'lName---------------------------------
If Not IsNull(rst!lName) Then
strString = strString & rst!lName & vbTab & vbTab & "|"
End If
rst.MoveNext
strString = strString & vbCrLf
Loop
objWord.ActiveDocument.Bookmarks("aaa").Select
objWord.Selection.Text = strString
objWord.Visible = True
my question:
I want to export the data to a table in word.
I attach the file
(to work good put the file "doc3.doc" to "c:/")
how can I do it?
thanks :)
View 4 Replies
View Related
Nov 9, 2006
The company are using Access 97 as the front-end to a SQL2000 database. Tables are updated, queries run and forms used. They are moving to SQL2005 but not considering updgrading Access 97. Will the current queries, forms etc still work? Thanks.
BB
View 2 Replies
View Related
Jun 5, 2007
Hi,
I have packaged my Access 2000 program using SageKey. When I open the installed runtime version of the database, and click on a menu button that performs a databse backup, there is no error, yet the file does not copy (note that I am using a function that utilises apiCopyFile). It does not do this in the full Access version where I have developed the program. Does anyone have any idea why it is doing this? And any suggestions to how I could fix this or change my approach?
Cheers
Tania
View 1 Replies
View Related
Aug 9, 2005
This happened yesterday at work.
The access form froze and they could do other things but Access remained frozen. They logged off and when they went back in Access opened but none of the form buttons or links were working.
The database is not split because it is used only by one station at a time.
Has this happened to anyone and does anyone know the cause?
Five people were trying to fix it when I walked into work (5 people who no nothing about Access other than using that one database) and I couldn't get a straight answer.
Thanks
Kim
View 5 Replies
View Related
Jan 23, 2007
There are posts elsewhere on this forum about the adjustments you can make to Access to improve its performance on a wireless network, i.e. make sure you have XP SP2 and not an earlier version of XP, but the fact is that no programme will perform well on a network if the network isn't performing well. Here are a few things I've learned (the hard way!)
- Use USB wireless adapters, not card type adapters. One of the prime rules of wireless networking is to keep your adapter - and your Router - away from electrical equipment and metal objects, so why anyone even makes card adapters is beyond me.
- Place your adapters/Router as high as possible (above head height is best) using a USB extension lead for the adapters if necessary. Do not put them on or near metal filing cabinets!
- Think about line of sight when placing your equipment. If your Router and an adaptor are just on either side of a wall , opposite each other, the signal may only have to pass through, say, 6 inches of wall. If they are at opposite ends of their respective rooms, however, it may have to pass through several feet of the same wall!
-If there are other wireless systems nearby using the same channel as yours, change yours to a different channel even if the other signal is weaker than yours. Remember that you need to be 5 channels away from anyone else before there is 0% overlap in the frequencies. If you cannot achieve this because there are too many nearby networks, any difference is better than none.
I have a 9 user (each in a separate room) p2p network in my office running a split Access 2000 db. The place looks a bit odd with USB adapters stuck high up on the walls but it works. Only one user has the occasional hanging problem (about once a week) but she's using an oldish laptop with only 256k of RAM and it has to run Norton Internet Security at the same time. Three of the users have the db open more or less constantly, the rest have no problem or speed issues getting in whenever they wish.
Nearly forgot, our Wireless system is standard 802.11g. max distance from an adapter to the router is about 80 feet.
Sorry if any of the above is stating the obvious, thought it might help.
View 1 Replies
View Related
Mar 18, 2008
Having grown weary of the speed related issues and numerous bugs - I have decided to Uninstall 2007 / reinstall 2003. Now, howver I find that the uninstall fails and then rollsback.... what a pain in the a!
JPG attached shows the dialog that results when I try to remove. Does anyone have any ideas why this is happening - the folder in question does exist and I am System Administrator with full privelegs for write access etc. on the machine!
Why does this (poor excuse for an improvement) software persist in plagueing my life...!
I really would rather not have to reformat the drive to remove all traces of Office 2007.
View 10 Replies
View Related
May 19, 2015
is it really possible to make a work flow in access? And if so, can it be done in Ms Access 2010.
View 2 Replies
View Related
Jun 28, 2006
I am trying to execute the SQL below (tested in other programs, works fine) but access is giving me the "join expression not supported" error. How can this query be used in MS Access? I have tried breaking some of the joins clauses into separate queries, but I can't get it to work and it is making things much more complicated. Also note that moving the join conditions to the where clause could impact performance (this is a very large DB) Could I execute this via code somehow? Thanks.
SELECT lp.loan_id, lp.days_delinquent, lp.current_balance, pc.product_name
FROM mtgwl.loan_payment lp
inner join mtgwl.deal_loan_relation dlr on
lp.loan_id=dlr.loan_id
and lp.time_out='9999-12-31-23.59.59.0'
and lp.as_of_date='2006-04-30'
and dlr.time_out='9999-12-31-23.59.59.0'
and dlr.type='DEAL'
inner join mtgwl.deal_loan_relation pdr
on dlr.deal_id=pdr.loan_id
and pdr.time_out='9999-12-31-23.59.59.0'
and pdr.type='PRODUCT'
inner join mtgwl.product_control pc
on pc.product_id=pdr.deal_id
and pc.time_out='9999-12-31-23.59.59.0'
and pc.product_name='GSAMP 2003 AHL'
View 2 Replies
View Related
Jun 28, 2006
I am trying to execute the SQL below (tested in other programs, works fine) but access is giving me the "join expression not supported" error. How can this query be used in MS Access? I have tried breaking some of the joins clauses into separate queries, but I can't get it to work and it is making things much more complicated. Also note that moving the join conditions to the where clause could impact performance (this is a very large DB) Could I execute this via code somehow? Thanks.
SELECT lp.loan_id, lp.days_delinquent, lp.current_balance, pc.product_name
FROM mtgwl.loan_payment lp
inner join mtgwl.deal_loan_relation dlr on
lp.loan_id=dlr.loan_id
and lp.time_out='9999-12-31-23.59.59.0'
and lp.as_of_date='2006-04-30'
and dlr.time_out='9999-12-31-23.59.59.0'
and dlr.type='DEAL'
inner join mtgwl.deal_loan_relation pdr
on dlr.deal_id=pdr.loan_id
and pdr.time_out='9999-12-31-23.59.59.0'
and pdr.type='PRODUCT'
inner join mtgwl.product_control pc
on pc.product_id=pdr.deal_id
and pc.time_out='9999-12-31-23.59.59.0'
and pc.product_name='GSAMP 2003 AHL'
View 1 Replies
View Related
Aug 31, 2012
I have a Access front end connected to a MS SQL database using a ODBC connection which is working fine of course.
When I compile it as a runtime version and install it on the business computer I get an error with the ODBC connection (I can't remember exactly what pops up). On the business computer I have installed SQL Native Client and in the ODBC added a System DSN (which works).
View 12 Replies
View Related
Aug 3, 2013
I am trying to prepare a mini budget program in ms access for my personal use in my office , but every time i fail to do so, my tables are as under
Field Name Properties
Code ID AutoNumber
001 Cash
002 Bank
846 conveyence
dt: Date/time
Code text (list selected by drop-down list)
des Description
Bill currency
yearly Budget currency
quartlyBudget currency
Query Question:
Group Aggregate function in my Budget data base file
(A) (B) (C) (D) (E)
Code yearlyBudget quaterlyBudget quaterlyused Budget Available Budget
846 50000 12500 5000 7500
850 100000 25000 20000 5000
There are 100 entries in code no. 846 and 50 entries in code no.850 the above given amount is total of each code no.
My question is that how can i get result subtracting amount in column (D) from column (C) to get result in column (C)
Budget Available: in Code 846 i.e column (E)
View 3 Replies
View Related
Sep 24, 2013
I recently completed a db for a client and they have since asked that the access window be hidden for certain types of users.This I did using
Code:
ShowWindowAsync Application.hWndAccessApp(), SW_HIDE
if a relevant user opened the db. All well and good, except they then wanted to be able to see the Access link in the taskbar (which SW_HIDE doesn't do) - so I changed it to SW_MINIMISE and they were happy again until..They then realised (and it was a surprise to me as well) that the right click context menus used to filter and sort continuous or datasheet forms were no longer available to these users - nor was the context menu for datasheet columns to freeze or hide columns - see attached.
I've experimented with a number of options and these context menus are available if ShowWindowAsync is not called or if called with SW_HIDE, but not for SW_MINIMISED, SW_SHOWMINIMISED, SW_SHOWMINNOACTIVE, SW_SHOWNOACTIVE.
Why the shortcut menus are not available when the Access window is minimised? The requirement being that the context menus are available to all users the Access link appears on the task bar for all users the access window is hidden for some users.I should say that due to hiding/minimising the access window all forms are popup and modal.
View 1 Replies
View Related
Dec 13, 2012
I have an Access 2007 application where don't work the link table manager.
I also try to complete reinstall the Office 2007 and also I register the Accwiz.dll in the office folder (regsvr32.exe Accwiz.dll) but the module still does not work.
View 2 Replies
View Related
Feb 27, 2006
We are creating a simple database to maintain driver license information for faculty, staff, and students who use cars from the university’s motor pool.
To do this, I have created two tables: tblDRIVER and tblLICENSE.
The fields in tblDRIVER are:
pkfDriverIndex
strLastName
strFirstName
strInitial
strAddress1
strAddress2
strCity
strState
strZIP
datBirthDate
The fields in tblLICENSE are:
pkfUpdateIndex
fkfDriverIndex
datDateUpdated
strState
strLicNumber
datExpirationDate
ynViolations
ynActive
Information about the driver is stored in tblDRIVER and the driver’s license information is stored in tblLICENSE. Periodically, we run a report that identifies drivers whose licenses are due to expire within a certain number of days. All this works fine.
My problem is that I am trying to create a lookup form that will load from a data entry form that will permit the Motor Pool Clerk to look up a driver by name and review the licensing information (which appears as a subform).
All this sort of works- I am using a combo box (based on a query) to look up a driver’s last name (which it does) and to populate all the driver’s information on the look-up form (including license information in a subform). Currently, the combo box locates the driver (including the unique index, last, and first names), and populates the form with first and last name but the rest of the information is not displayed on the look up form. Worse still, sometimes one driver’s last name matches up with the first name of the next driver listed in the table! This seems to happen only if a look up is attempted more than once. What gives.
Thanks for the help.
View 9 Replies
View Related
