Hi,
Ive try these steps, but i keep getting the same problem. But if i open my code then access my application,it doesnt crash. I'm really stuck.....
ramab
Last Activity: Aug 11 '08, 10:24 AM
Joined: Jul 10 '07
Location:
-
Corrupted database!!
Hi,
Each time im trying to access a particular form, my application crashes and gives me "Microsoft access needs to close.....sorry for the inconvenience". I have try all ways to repair my database but i still get the error. Im using access 2007. The thing is that, when i open up my Microsoft visual basic code and when i access my application, it doesnt crash!!!!it saves the form correctly. And if i closes the visual basic code,... -
Sending email from Access to multiple users
hi,
i'm a bit stuck here in sending emails to multiple users which i need to read from a database. With codes below, i able only to send 2 recipients. any idea how to send to multiple users?
thx
...Code:strSubject = "Test Memo sent at" & Now() strDest = "email" strCopy = "copy_email" Set Session = CreateObject("Notes.NotesSession") -
How to start an autonumber at a defined number!!
Hi,
Can anyone help me on this. Im trying to start an autonumber a t a defined number. e.g i want it to start at 150 instead of 1!!!!
Thx. -
Merging 2 databases in Access 2007 with auto number in both table
Hi,
im trying to merge 2 databases having the same structure. How do i merge the two databases which have unique identifiers and auto numbers. e.g the first 10 records in table A , it will have auto numbers from 1 to 10 and table B will also have auto numbers from 1 to 10. So will i merged them into 1 table C whereby for e.g table C will have auto numbers from 1 to 20??
Thx in advance. -
Form to be in readonly but some fields can be edited
Hi,
i want to make a form in readonly which contain around 60 fields but i need to make some (maybe 4) taht can be edited.can i do that??
thanks in advance -
hI.
;-)Yes exactly. Is there a way around for it not to appear in the other subforms(datash eets)
Thx...Leave a comment:
-
hi,
ive got a table that have 14 fields. among them, 7 fields are found in all 3 datasheets(this include the 3 primary keys). The rest are distributed in the 3 datasheets. when i enter data in my 1 datasheet, it is recorded also in the other 2 datasheets. if i enter 3 records in my 1st datasheet and move to the next datasheet, it will prompt me to enter data in the 4th row, because the first 3 rows contain data that pertain to the previous...Leave a comment:
-
Removing empty rows in datasheets - Access 2007
hi guys,
I can't figure out how to solve this problem.
I have got 3 tab pages containing 3 datasheets based only 1 table. i have 3 primary keys in the table.Two primary keys are found in the 3 datasheets. My last primary key has an auto generated number. when i enter data in the 1st datasheet, for e.g when i filled in the first two rows, and then afterwards i filled my next datasheet, i will need to enter data on the third row. the... -
Migrating from Access 2003 to Access 2007 - Problem
Hi friends,
Ive did a small application in access 2003. it comprises 1 databases, one contain tables and the other queries,forms,r eports. ive saved the file in Access 2007 and has already linked the two databases. My problem is that the buttons on my forms doesnt work. When i click on them,nothing happens. Plz help
Thx. -
Plz help..im stuck.......... ......Leave a comment:
-
help documentation for acess
Hi,
i'm having problems in inserting my help documentation (CHM file) on to a form. I want to place a button on the form where the user can click to access the chm file.Or is there another way the user can access the file??
Also,if the user press F1, then the user will be given the help for that form but it does not give the user access to the index and search tab. Any idea why the user doesnt have full access to the CHM file.
... -
Thx a lot. It work;-)...Leave a comment:
-
Hi, I hope the detail below is ok. Thx
The crosstab query
The SQL
TRANSFORM Count(CORRECTIV E_ACTIONS_V6_1. FOL_STAT_CODE) AS CountOfFOL_STAT _CODE
SELECT CORRECTIVE_ACTI ONS_V6_1.DEPT_N AME, Count(CORRECTIV E_ACTIONS_V6_1. FOL_STAT_CODE) AS [Total Of FOL_STAT_CODE]
FROM CORRECTIVE_ACTI ONS_V6_1
GROUP BY CORRECTIVE_ACTI ONS_V6_1.DEPT_N AME
PIVOT CORRECTIVE_ACTI ONS_V6_1.STAT_D ESC;
...Leave a comment:
-
Hi,the thing is that "pending" is the field generated when i run the report. if i previously run the report where the heading pending header is generated,then when i run my report again but that there is no pending field,it will give me Microsoft jet database engine error.
Thx...Leave a comment:
-
From cross tab query to report: Error Microsoft jet database
Hi friends,
Im getting an error [The microsoft jet database engine does not recognize" " as valid field name or expression] when running my report which is related to a crosstab.my crosstab query will display null but when i run the report some of the fields are blanks.
e.g In my cross tab query:
Completed: 2
InProgress: 3
Pending:
But when i run the report it does not recognize the field pending... -
Automatically accepting/Rejecting Msg error in access
Hi.
My program is giving me some errors,but i want to capture them so as each time i dont need to click "Yes" or "No". I want the application to accept/Reject the error so that my application can proceed.Plz help..
Thx -
Go to last record in database???
hi. i am trying to access the last record in the database to do some calculation with it. Does anyone know which method to used. Ive tried DLast but it take a random number and not the last record.
Thx -
How to a Combo Box to a default value
Hi. A have a combo box which has a list, "Yes" & "No" on a form,i am trying to set the value to "No" in that combo box when the forms load. Any ideas.!!Thx. -
How to disable a field in a form?
Hi, i have a field 'UserCreated' where i automatically get the user which has login. Its like an audit trail. But then i can changed the user name.How do i disabled that filed. thx
No activity results to display
Leave a comment: