Tagged questions

1000 results found

TimeOfDayAugust 18, 2011

I'm trying to use TimeOfDay in my code to enter the system time into a table (field "Time") each time the user enters a record. My code (simplified): Dim currentTime As Date currentTime

17

views

0

votes

2

answers

Access 2003 Application slow when multiple users are using it.August 18, 2011

We have an Access 2003 application that has a backend .sto database that resides on the server and a frontend mde that resides on several machines. What we have found is that when one user is using th

16

views

0

votes

2

answers

Group Policy Management Console To Some Child Domains - Access DeniedAugust 18, 2011

I have a top level domain with 5 child domains running Windows 2003 Server.  From tld domain controller, I can access Group Policy Management Console to all child domains but two.  I get acc

16

views

0

votes

7

answers

Fix Tab Order on SubformAugust 18, 2011

I have a form with a subform that has 6 fields. I set the tab properties on each of the fields so it tabs through in the order we want to enter data. The problem is when I leave the subform and click

22

views

0

votes

3

answers

How do I loop through an array through variable datesAugust 18, 2011

Hi, I have some code that loops through an array and produces a series of table. This works great. However, I now want to be able to vary the dates within the query. So, I tried to nest the original F

25

views

0

votes

3

answers

Changed User Permissions while files being accessed, now folders/files corruptAugust 18, 2011

Today, while various employees were accessing the shared excel files located on our fileserver, I was fooling with user permissions on the server. However, everyone was using the excel files as

30

views

0

votes

7

answers

Compact and Repair with Access 2003 on a Windows 2003 / Citrix Terminal ServerAugust 18, 2011

Background: We have an Access database stored in a folder on the local file system of a Windows 2003 Server.  2 users access this database file (which is an Access 2000 file, default format in Ac

37

views

0

votes

6

answers

Caculations in queries to find cumulative amounts run again every time they go off screenAugust 18, 2011

I am new to Access and this is probably a very easy problem.  I am running a query in Access with calculated fields and it is giving some very strange results. I have a query which takes the amou

26

views

0

votes

8

answers

Lock Record based upon ValueAugust 18, 2011

Good morning Experts, Got an interesting one. Have a table named (tbl_Adjustment_Details). This feeds two forms: 1) sfrm_Adjustment_Details - A subform that is used by data-entry users, to enter adjus

27

views

0

votes

2

answers

Error 3464 - Data type mismatch when using "DISTINCT" in SQLAugust 18, 2011

I am needing help with queries that I am working on in MS Access 2003.  I currently have 3 groups created that share the same information, yet they have different factors for calculation.  I

62

views

0

votes

11

answers