Trying to close a form when empty
Fri, 10 Oct 2008 15:06:00 -0700
Hello All
i am working on a form that pops up when a user logs in and has at least 1
of any number of 5 types of items. for instance the item types are issues,
service, warranty, order, returns. if a user has created any 1 of these items
and it is older than 14 days and has not been "finished" a form pops u ...
|
Passing a null value to a query
Fri, 10 Oct 2008 14:23:01 -0700
I am designing a form that allows a user to specify query conditions. I run
into trouble is the user does not want to limit on a particular item.
I have a form, fDrill that has three combo boxes, once of which is for the
customer name, cboCustName. The query that uses these conditions is qDrill.
The Cus ...
|
Union Query ... Is this right?
Fri, 10 Oct 2008 13:41:00 -0700
I'm going to try this again, maybe hopefully, I'm heading in the right
direction.
I have 2 tables, one with Action Items ane the other with all related Action
Items. Each AI can be related to more than one other AI.
So,
Tables are:
tbl_AI
tbl_AIRelated
tbl_AI has following fields:
AI_PK
AI_Descrip ...
|
Delete won't delete from query/form
Fri, 10 Oct 2008 11:08:03 -0700 (PDT)
I'm mystified. I have a pretty simple table with company name
information which has a one-many relation with a table with dates.
They are connected via the companyID.
I've created a left join query (all the records from the company even
if there are no dates). I've then used the query to create a
continuous f ...
|
Combobox AfterUpdate to existing record
Fri, 10 Oct 2008 10:46:40 -0700 (PDT)
I have a combo box that's used to navigate records either by making a
selection or mouse button scrolling it. The problem is that read-only
users can't use it as the AfterUpdate code is disabled for them.
What's an "easy" AfterUpdate code for comboxes that will allow all
users the ability to make selections or ...
|
Filter
Fri, 10 Oct 2008 10:46:00 -0700
Hi:
I have a form based on query that filters on a userâ??s Sales ID, when opens.
for example the form for a specific user has 20 records; 10 of them are
locked (budget) and 10 can be edited (forecasted); Once the first forecast
record is found and a filter is applied to get just the ones for forecast (10
...
|
user access
Fri, 10 Oct 2008 10:37:19 -0700
Hi All,
I searched is forum for help on how to put password on forms (or just put
some kind of restrictions) and didnâ??t find anything.
I want to allow certain users to have access to certain forms in my MS
Access db. Can that be done?
When the user opens the db in Access and clicks on a form, the d ...
|
|
|
using an if statement in a command button?
Fri, 10 Oct 2008 09:16:00 -0700
Okay here we go, I have a form with 3 radio buttons on it, each one is an
office location. I have 3 reports, each uses a different letterhead for the
3 offices. Can I create a single command button to run the appropriate
report based on which radio button is selected? I'm really not sure if there
is some c ...
|
Break points HELP!!
Fri, 10 Oct 2008 08:44:04 -0700
Hi
I have an access 2000 application.
I have various code on the on open event of the welcome menu form, which i
wanted to test today. I put breakpoints in the code to test and then when
finished i cleared the breakpoints.
but..............
They haven't gone away, everytime i open the database it bre ...
|
Microsoft Web Browser Scroll Bars
Fri, 10 Oct 2008 14:27:12 GMT
Hello-
Utilizing Access 2007, I am utilizing the Microsoft Web Browser control to
show a animated gif image as a progress bar while a subform loads. I am
passing a path directly to the gif file on the .navigate. Everything works
except that the control shows vertical scroll bar and a lot of white space.
Is ...
|
