Search results

Hi, all-- I came into a database where the forms have checkboxes connected to table fields that are in text data type. I see that when the checkbox is checked, the value in the field is still -1 in the table. Is there a reason to change these fields to Yes/No data type or just keep them as...

I have a listbox that I am using as a lookup tool on a form header. There are also parameter fields there whose sole purpose is so that any combination of paramaters entered will effect what records show in the list box. Clicking a record in the lisbox will then produce the appropriate record...

I have a split 2003 (.mdb) database accessed via 2007. Our users suddenly started getting a ""Unrecognized database format" error apparently for the backend database only. I tried to open it in 2010 and I get the same thing. I have made no changes that would bring this about. Any ideas of...

Hi, all-- I have a basic report with two summaries (sum and a summary based on an expression) located in the group footer. When I try to export the report to Excel, I get the first summary but not the based on the expression. I've tried having them on the same row or one on top of the other...

Thanks for your response, David-- I found out that the mdw file considers the users and groups configuration but object permissions are house on mdb file. That means I have to make the change on one mdb file and replace every user's mdb file with that one.

I have a shared database (mdb file accessed through Access 2007). Users access the file through a shortcut which includes an mdw file for user security. Each user has a front end application on their hard drive, and the mdw file with the backend database is on a shared server. If an...

Hi, All-- I obtained from online a function (DateAddW) that returns a dateadd based on weekdays only. Although it seems to work, it's format seems to be other than a regular date. I get a date and time returned (the sourse field in the function is formated with data and time). However, it...

Hi, all- I am using a dateadd function in a querie. The field used is formated for (and masked for data entry with) date and time. The function works fine. When I run I get date and time. However, I want to add criteria to the query to select from between two dates for the expression...

jcribby, I first want to say I am not able to help you with your question. Sorry. However, I'm needing to get into moving from a usual Access multi-user application to a web-based application and don't seem to find much on this here on this forum. What web-based software did you use? I'm...

Greetings, all-- I am redesigning an application to have a data entry area seperate from a records access area. The current form makes use of tabs and a subform in each tab. I want to basically duplicate this for the data entry form which would be opened in dataentry mode. Is it a good...

I have a split Access 2007 database that users access via Access 2007. The BE is in a shared server location. I use the user-level security feature of Access 2003. We are finding that when multiple users are in the database (each has their own application on their own hard drive), the...

I was sent the program's copy of the MDW file and I also didn't get a log-in although my own copy worked fine. I'm sending that copy over to them with the adjustment you recommended. Thanks for your help.

I believe you, but when I tried logging in as admin I got a "Not a valid account name or password." I will remove the account but will that make things normal again?

They are using a short cut (no modifications have been made). Admin is still a member of the Admins group although there are now other users in the group. This has never been a problem before. It has worked fine until this morning.

I have an Access 2003 db being used through Access 2007 in order to use user-based security. It is a spit db with the be being on a shared server. For some reason, the security login has been deactivated after working fine for over a year. The user goes right to the autoexec macro file...

Hi, all--I have a database that was designed originally designed in A2000, saved as an A2007, then (I think) saved as an A3003 in A2007 to maintain the user security features of A2003. Would this have any impact on performance? I have a split DB where the users are having all kinds of...

That's what I thought. Thanks.

Pat, please help me to understand the second part of your post from 6/26. The image addresses are in a table called tblStaff that is part of the BE. Are you saying that I should create a FE table of the same configuration and append the records from tblStaff to the FE table on database...

Thanks for your responses and suggestions. I'll try them all. The files are small: 150-200kb but I'll test to see if the files themselves are the culprit. We are looking to try to eliminate printing-more having an EMR kind of thing, so it would be nice to have the signatures visible in the...

I have a split Access 2007 db (actually an 2003 mdb viewed in 2007). The BE is located on a server and the FE is copied on each user's hard drive. I have bitmap images of each user's signature which are stored in a folder on the server where the BE is. The location is stored on a field in...