Search results

I have a data enter form. at some fields, I put 0 as a default value under data tab for that filed property. However, it does not work. the linkable oracle still shoe nulll value. What kind of issue is in here? Thanks new access

Thanks for forum expert suggestion. I just use command to close form without save. UNDO or CANCEL button does not working in my case.

I use form wizard to auto generated a form to add data form. When user opne a form with default value assigned. But if user does not like tot enter data and want to close form. access 2007 display message: ODBC-call failed Microsoft[ODBC driver for Oracle][oracle]ora-01400 can not insert null...

I use form wizard to auto generated a form. I want to clear past added data on the form when form opening. i find solution in gogle. just as test_name .Value = ""

I have access 2007 on window 7. I use form wizard to auto generated a form to add data. Now I want to clear past entered data when form open. Otherwise, I can see last enter data during open a form. on form current i put Me.test_name = Null But I get error as RUN-TIME...

just copy code. I still learn access as beginer

I have two table (oracle linked table and access table) with same structure except data type in oracle database and access. data type convert as oracle number -->access integer varchar2(80_-->access text size 50 there are only tow column. no index and key. the error message as ODBC-- insert on...

Thanks for your URL. It works for me. new access man

Hi Friends, I have a form that used to input data. there are a column as primary key at oracle table and value comes from oracle sequences. the query works in database. However I got a message as run-time error 3078. the Microsoft access database engine cannot fine the input table or...

Very good advice! Thanks Bob!

Hi Bob, Table is in Oracle database with a linkedtable in access. that you means do validation rule in VBA codes. it is a idea The filed validation works before clicked reset button It seems that no way to broken by reset button. Thanks Jimmy

Hi Experts, I created a added data form with input text box. I set a validation rule in there. such <1000. However, even I remove all number in text box, but I still got validation message and much enter quality number (<1000) before closed form. I set a reset button with codes as...

Thanks for every experts. I just used previous backup file to fix issue. I still do not know which issue resulted in ACCDE does not work. Does not mattaer whether we connect ODBC during ACCDE created. Thanks Newaccesser

Hi Experts, I created a data enter forms and works will linkedtable that by ODBC in Access 2007 . Yesterday, I made a ACCDE and works well. Today, I made a ACCDE from access application and does not appears a ODBC connect box. Why ACCDE does not linke to ODBC? are there something I make...

Thanks. I got it.

Hi Experts, I am learning Access 2007. I put a message in msgbox as MsgBox " Data Enter Error No: " & Err.Number & "; Description: " & Err.Description & "Please contact Developer" However, system display all information at one line. any way to put into 2 or 3 line at messagebox? Thanks...

Thanks very much. works!

Hi Experts, I have an inserted data form at access 2007. It works. But The added data is still exist in text box after data inserted. I added Me.Refresh to refresh it. But is does not work. Do we have any way to clear "old added data" from input test box? Thanks very much! NewAccesser

Hi Bob, Thanks for your help. I just need single max value (sale_number columm ) from a linkedtable. Thanks Newaccess

Hi Bob, I just need to get a return mac sale_number value from sql in VBA code and then assign it to local variables. How can I do that ? Thanks Newaccess