I am trying to amend a database i have and are stuck on how to structure / code a couple of issues.
I have documented the structure in the code section and questions in here
Table 2 does...
i have a three part of the form... Ist form get the data from tableA. Second part get the data from a query (Where query populate data from the tableA and with some criteria.) Now i have make ...
I created a very simple database,
which includes compay table, service table and company_service table as an associate table
Company table: Company ID, COmpany Name, Service ID
Servic...
The on update does not seem to work on the activex slider control, any clues ?
I have 1 table with like 100 check boxes. I need to create a report that only has the True boxes otherwise my report will be like 5 pages long for each record. I'm using Access 2003. Any ideas?
Hello everyone,
Is there a simple and fast way to grab records only from this month? I have been searching all over and getting different results.
If I use:
SELECT ACTHIST.SREP_CODE, ACTH...
Does Access 97 have an upgrade tool to Access 2003?
Hi
Can anyone help me in this issue as I want to implement security in a VBA project
Actually I was able to set password for the code part of the project but I want to implement security e...
Hi,
Ive got a report which has been designed in Access 2003. The report is a two page affair with various company data on the report. In the background there is an A4 jpeg which has the app...
I have a requirement ... sofar the company is maintaining the application using VBA (MS-Access with VB as the front-end) . Can anyone help me the easiest way to migrate the application into VB...
I am running two separate queries and obtain 2 recordsets. One of the queries ia an standard query and the other is an aggregate query. One will return a measurement for a person while the o...
I am attempting to populate a Treeview to display a Build of Materials.
I used the code from Microsoft which works well to display Employee-Supervisor Relationships. However when a Part# i...
Hi,
I would like to Compact my Database on Close of the Menu Form. I am using Access 97, the Database is on a Server with 3 users. I would like it to Compact if there are no other users in ...
How do I view the list of queries when designing a blank report. I can see the list of fields availbe from the tables but not the queries.
Table A
Cust ID
Full Name
Table B
CustID
Full Name
How can I return all records in Table A, omitting CustID if it exists in Table B?
Hi,
I have some code which allows me to capture key presses when using my Access Database. For instance, I can write a pop-up menu item that will do different things based upon whether I a...
I have a form with a button that says Print Record that ideally I would like to just print the record being viewed (although currently I am cheating and have it ask for the ID number which is ...
I have a form that has a preset amout of buttons loaded. In turn, I have a table that holds the event codes that get assigned to each button when the form opens. I originally wanted to build t...
how can i create tabs in the orm as in the templates in access 2007?
Is this possible? How woud it be done? Thanks!
How can I create calender or reminder or notification in access 2007?
for example the task is assigned to Sara.. so we need automatic notification to be sent to her..
Moreover, when the task...
Hello,
I have created the password for the form, as directed by the experts here, but i have to create another password for the form, that has "add material number". I have attached the datab...
Can I set certain fields on my form so when a user is adding a new record they cannot leave those fields blank? If so, how?
I have the following Table
Cust ID Week Fee Payment
1 1 250 10
1 2 150
1 3 ...
I have a button on my form that is set to open ianother form in datasheet mode. Is it possible to get this window to open at less than full size? I'm a total code newbie, so I also need some...
