Search results for query: *

First, let me thank this Forum for tremendous help you have given an Access newbie over the past few years. You have helped me solve many Access problems involved with the non-profit Food Pantry where I volunteer, and I very much appreciate the help. I currently have a need to get Access to...

I am running a split Access 2007 database(a BE desktop server and two FE laptops) at a non-profit food pantry. I have posted several questions here over the past few months about this database running quite slowly, but have up to now had little success at fixing the speed problem. I have...

You guys have heard this scenario before. I am running a split Access 2007 Database at a non-profit Food Pantry. There are 2 Laptops running the Front End Database part connected by wired Ethernet to a Desktop running the Background Database Part. We have recently simplified the Ethernet...

I am running a split Access (2007) database at a non-profit. It consists of two Laptops with a copy of the FE database, that are connected by wired Ethernet to a Desktop with the BE Database. All three computers are running Windows 10. That means that both Laptops are simultaneously accessing...

I am attempting to learn to debug VBA code in Access. I believe I understand the use of the Immediate Window and the Local Window. I understand the use of the Debug.Print command. Would someone please explain to me how to get Access into Break Mode in order to step through and execute the VBA...

I am running a fairly complex Access 2007 multi-user Database (a .accdb Database)at a non-profit Food Pantry. A while back we split that database into backend and frontend parts. However, the split did not seem to go as expected. We did end up with forms, queries, etc. in the frontend, but...

I am responsible for a small split multi-user Access database at a Non-Profit Food Pantry. There are two users on laptops (running a front end version of the application), which are communicating with a desktop in the back office (running a back end version of the application) via Ethernet...

I wonder if one of you Access Gurus can explain a slow down I just saw. I am responsible for a simple Multi-User Access 2007 System at a non-profit Food Pantry. This Application is a split Database, where two Laptops at the front end (both running Front-End split software) communicate via...

I have a need to write several values directly into text boxes in an Access Report. Can someone please explain to me (Access Newbie) how to do this?

I have a need to create a single-record table, where there is just one row of fields, that gets written over top of over and over again from a form. Currently, my Table just keeps on growing, and I'm using a query to select only the row with the maximum key number. But this seems like a sort...

I have another Access Newbie question. I have tried searching these Access forums for this, as I suspect it has been asked and answered before, but any way I try to search my question I get 1000 hits. I would like to know if there are any problems with having one Table of data present in two...

Does anyone have an idea why the VBA Line below works on some Access 2007 computers and not on others to print an Access Report? DoCmd.OpenReport "rpt_CardType_Ron", , acNormal I would also like to know if Importing an Access Form from one Access 2007 Database Application to another should...

Does anyone know why the fairly straightforward VBA command below works with some Windows 7 computers running Access 2007 and not with others? The command is DoCmd.OpenReport "rpt_CardType_Ron", , acNormal The broader question is that I am trying to update a few forms and add a few tables and...

In Access (I'm actually using Access2007), when I use a Wizard to creat a Combo Box on a form to look up a value in a table, Access creates the attached Macro to occur on the "On Update" event of the Combo Box. It directs Access to do its normal string search, starting at the beginning of the...

Is there some resource that would help a newbie to Split Databases learn some of the cardinal rules, like "Don't Do This" or "Always Modify a Table In The Part That Contains The Tables - Not Links To The Tables", etc.

I need for an Access Volunteer Database Application (keeps track of Volunteer schedules for a non-profit) to output a Calendar-Like Report. I am aware that many past posts on this Forum refer to examples of such a Report on Duane Hookom's "Hooked On Access" Website, but that Website no longer...

Would someone please help me out in understanding what the following line of VBA Code is supposed to do: Me.FormName.Form.Filter = Mid$(Selection, 5, 999) This code line follows a series of lines that appear to check to see if certain fields from a second Formname contain anything. I know...

I have a need to write an expression in a Query, which performs two conditional tests at once. That is, something like "If X is true and Y is true, then print Name", or "If X=N and Y=M, then print Name". It would be ideal if the Immediate IF Function (IIf) would allow two tests within the...

At our local food pantry we are running Access-based software on a Windows XP desktop server. Volunteers who are dealing directly with Clients work on two Windows XP laptop computers that are wirelessly connected to the desktop computer via a wireless G network. Thus, the laptop computers are...

OK, so I have abandon my previous attempts to modify an existing database and have bought the book, Absolute Beginner's Guide to VBA", by Paul McFedries to start from scratch. For the Access VBA part of this book it starts out telling me how to program via an ADO Object. However, I can not get...