For question relating to Microsoft Access, use the tag 'microsoft-access'. This tag is not helpful and should not be used at all.
0
votes
0answers
21 views
How can I use expressions in access to populate fields? [migrated]
I need Access to generate a reference number for me. The reference number is to be the first letter of the Last Name and then an auto generated number. The number generated must be incremental for ...
0
votes
0answers
9 views
Access Query Designer Woes — select by multiple values not working
Table 1 Names
Table 2 Services
If I do a simple select of both tables together, I get a list as follows:
Name1 Service X
Name2 Service X
Name2 Service X
Name2 Service Y
Name3 Service Y
Name3 ...
2
votes
0answers
45 views
Microsoft Access 2010 Error
Ok, so I am not a pro in MS Access (or databases), but I tried googling this and no answers, so here goes nothing:
I am trying to create a field to convert currencies from one of 2 fields, thus I am ...
0
votes
1answer
41 views
Share home WiFi connection temporarily
I have WiFi router at home and sometimes I have guests which need to access to the Internet via my WiFi. It's quite problematic though to give them password to my access point because I want to give ...
0
votes
0answers
35 views
How do I export to CSV without decimals using MS Access 2010?
Is there a way to export numeric data to csv file in MS Access 2010 without decimals? I am using ImportExportText in my macro. I don't see anywhere where you can specify this.
The macro is ...
0
votes
0answers
15 views
Passing Query Parameter to Sub-Report
It has been a long time since I have worked with MS Access and am not sure if I am doing this right.
I have a Report bound to a query of single list of user names. The report groups on the user name ...
0
votes
1answer
52 views
No access via cygwin to USB connected device (Samsung Galaxy tab II)
In Cygwin, I am used to being able to have access to a USB-connected device via a drive letter. For example, my Droid X2 appeared as E://, so I could do:
$ cd E:/<something>/
and get access ...
0
votes
0answers
31 views
How to manage access to many servers by a lot of users? [migrated]
I have a network of about 40 linux servers, running many different services. I want to have only one main server storing usernames/passwords and other users data in some kind of database. I want to ...
1
vote
1answer
39 views
Access calculated field special operation
I have a Microsoft Access table called calc1 with fields:
calc_ID (primary key, number)
calc (text)
I have another table called res1 with:
res_ID (primary key)
calc_ID (number)
dimensionbefore ...
1
vote
3answers
49 views
Lost root access possibility /sbin/nologin
I accidentally edited the file /etc/passwd on my server in the following way:
root:x:0:0:root:/root:/sbin/nologin
Now I can not login as root. When I enter the su command, Cannot execute ...
0
votes
1answer
57 views
0kb Access Database file, file not found
This could be related to Access or separate entirely. I have an access database in a mapped network drive that reads 0 kb and upon opening, Access 2010 tells me the file cannot be found. Other users ...
0
votes
0answers
10 views
Alternate User profile without internet access
I want to use two user profiles in Windows 7, the default one should have internet access, and the other should not get any chance to access internet. He should be able to access all the files but ...
-2
votes
1answer
26 views
Access 2002: “Undefined function 'Date' in expression” [closed]
Error appearing on MS Access 2002 database (.mdb):
Undefined function 'Date' in expression
Can anyone assist?
0
votes
0answers
52 views
advice on generating reports with Excel vs Microsoft Access
I have a Microsoft Access based tool that lacks the reporting capability I need. The tool is able to extract extract each table from its relational database as a separate CSV file. These files aren't ...
0
votes
0answers
91 views
Windows XP SP3 to Mac mini server Mountain Lion
I am replacing an old 1997 windows server with a mac mini server running ML server edition. I would like to store my old windows files on the new server as well as our MS Access database. Will it be ...
-2
votes
1answer
38 views
have values in excel, im trying to find the end result based on two sets of criteria
im trying to identify matches between column D & K, AND THEN, out of those matches, which ones have matches on column A & H. Basically columns D (ABC) & A (123) are linked, and K (ABC) ...
0
votes
0answers
251 views
Cannot open all .SNP snapshot files on Windows 7 x64
We receive .snp snapshot files from legacy MS Access databases out in the field. Our new Windows 7 x64 machines are running Office 2003 and the Snapshot Viewer (SNAPVIEW.EXE), however the vast ...
2
votes
0answers
59 views
Insert Excel Spreadsheet Into Word From Access Database
I have an Access database with Excel spreadsheets (files) linked to a field in each record.
In Word, I have setup a mail merge which picks up the data from each record and I want to insert the ...
0
votes
0answers
74 views
replace " with access replace function in query
I'm running a make table query for exported data and need to replace user typed " (double quotes with "
What I have is:
Thickness: Replace([Flooring Products]![Thickness],'"', """)
...
0
votes
1answer
457 views
Access 2007 wont open in 2013 just gives errors saying not compatible
This is my first attempt at a big access project so please be gentle :)
I have created a database in Access 2007 on my works PC and it is a .accdb format files. I tried to open it in Access 2013 on ...
0
votes
1answer
34 views
Can Access display a related field on a data entry form?
Let's say I'm building an Access database to hold recipes and calculate the cost of those recipes. I need a table of recipes, a table of possible ingredients, and a table of recipe line items.
Each ...
0
votes
2answers
82 views
Is it possible to convert an Access MDE file to an ACCDE file?
I wish to convert an MDE file to an ACCDE file.
Assume I don't have access to the original MDB file.
Thanks.
1
vote
2answers
57 views
How to forbid programs from accessing a folder
I use firefox as my default browser. IE and chrome are used as secondary browsers.
Apart from these, i need to have a alternate browser. I tried opera, but when installing it, opera automatically ...
0
votes
0answers
18 views
Accessing A Shared Directory That Has An Account White List
I'm on a LAN here at work and I have my desktop sharing some of my project folders. I can access the computer via \\ComputerIP\, but I can't actually open any of the folders. Upon attempting, I get ...
1
vote
1answer
481 views
Access query to combine two columns into one longer column with both sets of data
I need an MS Access query that will combine data from two identical fields in two different tables into one field. The two tables are "Payroll_2011" and "Payroll_2012"; and both tables have columns ...
-1
votes
1answer
79 views
How to connect to my lan from the outside (e.g. internet)
I want that my router will see me as an inside the LAN host when i access him from an outside IP that is not in the LAN so i can access my printer and storage device that are connected to him. I can ...
1
vote
1answer
267 views
Files not accessible
My system is running on a pc with C:\ Drive out of space. So I tried to delete some file and clean up to get more space. I found that the %Temp% {C:\Users\Username\AppData\Local\Temp} takes lots of ...
0
votes
1answer
90 views
linux: access mounted volumes as normal folders/files
I have a closed source software (client) running on a linux machine (debian) to deliver files to a backup machine.
This works fine except this client software does not access the mounted volumes ...
1
vote
2answers
55 views
Data permission: what if adding only write permision to a file?
What if a user got only write access to a file? Is he able to read the file or only to "write"? But if you can write...you can also read, so this doesnt make sense or?
The question is for unix-like ...
5
votes
2answers
6k views
How to get access to C:\Program Files\WindowsApps in Windows 8? [duplicate]
Possible Duplicate:
Where to find Windows 8 Modern UI apps source code?
How do I open the folder C:\Program Files\WindowsApps?
Currently I'm denied to enter. Even though I'm logged in as ...
1
vote
2answers
210 views
MS Excel and Access - which is better for reports?
Where I work, staff have just started to use a basic table in excel (1 october) to record sales which has about 10 columns (name, client, renewed, discount, paid etc). I record the data (total sold ...
0
votes
0answers
80 views
Windows 7 x64, TeamViewer not connecting
My remote computer was not logged in and I can not connect to it.
Actually I can, TeamViewer says "Authentication", then hides but no window appears.
What's that bug?
0
votes
1answer
36 views
Connect everything inside LAN but the internet [closed]
I've a modem with Wi-Fi and some other access point. If I connect to the access point of the modem, it works perfectly.
If I connect to the access point, I cannot connect to the internet although I ...
0
votes
0answers
127 views
Convert Word 2010 document to Excel or Access?
I have about 700 Word 2010 documents, each with 10 headings. I have to create an Excel file so that each line in it corresponds to one Word document and each heading of the corresponding document must ...
1
vote
0answers
32 views
Changing the connection information on a linked QUERY in Access 2007
This is about linked queries, not linked tables. With no linked tables, the Linked Table Manager is disabled.
I know how to see the connection of a linked query, linked to SQL Server:
...
-1
votes
2answers
186 views
IF value OR value Then [closed]
Using Access VBA we need to do an IF-Than statement but there are 16 values. So, I have tried including "OR" but this code returns error "Can't find the field 'I' referred to in the expression. Here ...
2
votes
1answer
2k views
Dokuwiki on Raspbian “wheezy” (Raspberry Pi)
I've installed the dokuwiki via apt-get. The first call to http://localhost/dokuwiki give me "403 Forbidden" as response:
Achtung! HTTP/1.1 403 Forbidden
You don't have permission to access /dokuwiki ...
1
vote
0answers
87 views
Access 2010 Superscript, Subscript, and Math Notations
I am creating an Access 2010 database to read rich text files full of math questions. I have the necessary fields in rich text, but rich text does not seem to support superscript, subscript, and ...
1
vote
0answers
92 views
Wifi Multi-AP Roaming, connected to single authentication server
We are thinking of setting up a configuration where 10 or so wifi APs are setup in our building all with the same SSID for roaming, connected to a wired ethernet for backhaul.
Our solution requires a ...
0
votes
0answers
155 views
Can I connect my tablet to the PC using VNC while connected to an access point
I recently relocated to South East Asia. I have stayed in a guest house for two months and my PC and cell phone are connected wirelessly to an access point.
The IP address of the PC is: 192.168.1.10
...
0
votes
0answers
52 views
Access Password popup
Using Access 2007, I have a login page which lists the names from a table. That table has a value for password. Came someone direct me as to to how to password protect the sign on. Another words when ...
1
vote
2answers
2k views
Windows 7 hangs with 100% disk activity but only when online
I have the same problem as seemingly many other people here, and I think we might all be experiencing the same issue: a compatibility issue in Windows 7 between hard drive and network controller or ...
0
votes
1answer
249 views
Changing the Owner of a folder back to SYSTEM
ISSUE1:
This is what I get when I try to open my C:/Documents and Settings.Although I am the owner of the computer I was denied permissions to open the folder. So, I changed the owner of Documents ...
-1
votes
1answer
60 views
How to deny access to network (Internet) for users group in Windows?
I have Windows 7 prof installed without any AD. Just notebook for example. And I need to create Users group with limitations to access Internet via my application. Some accounts needs to have access ...
1
vote
0answers
39 views
Restrict use of Microsoft Access? [duplicate]
Possible Duplicate:
Restrict use of Microsoft Access?
I'm trying to remove the ability for non-administrators to create databases in Microsoft Access.
My issue is that people are creating ...
0
votes
0answers
54 views
Folder is not accessable, owner is not changeable. What should I do?
I'm facing currently a problem with a folder in windows 7, that is not accessable. Such a problem I had treated often in the last years on several pc's. But today the problem seems harder than the ...
1
vote
1answer
533 views
Windows 7 Find Who Accesses a Shared Folder
could anyone help me in finding the access logs to a shared folder in Windows 7.
I would like to get information like the user name, time, IP, etc.
I have already looked into the Event Viewer to ...
1
vote
2answers
392 views
File locked / read-only
On a networked computer, I have a file which is coming up as read-only because someone else has it open. This is not true. This is a file stored locally on the computer and it is not being used by ...
0
votes
1answer
620 views
Remote access to ip camera
I am trying to set up remote access to an ip camera I've just bought. The camera is tuned wirelessly to my Huawei HG520B router and works fine on my LAN. My ip address is public, so I've set up a ...
1
vote
2answers
2k views
How can I get a list of fields AND respective tables used in an MS Access 2010 database?
I know this is how you get a list of all the tables in the database (and more if you modify the critieria:
SELECT *
FROM MSysObjects
WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0));
But ...
