Search results

George, Thanks for pointing me to Allen Browne's web site. He does indeed have a listing of DDL, DAO, and ADOX data types. Turns out that you can't access Decimal data type using DDL and the Access Query Interface. You have to use either DAO or ADOX to create a table with a Decimal data...

Hello All, I am trying to create a table in access 2003 using DDL, but I am having a wee problem with one of the data types. Decimal to be precise. Here is my ddl: CREATE TABLE SampleDataType ( Fld_Txt_50 VARCHAR(50), Fld_Txt_100 VARCHAR(100), Fld_Memo LONGCHAR, Fld_Long_Integer INTEGER...

Sorry for the naive question, but I appreciate the answer none the less! My background is mainframe programming so this object world and syntax is a little overwhelming. Thanks for being patient with me while I learn. Craig

Hello All, How do I retreive a value that has been clicked on in a listbox?

OK...now that has been cleared up. I create/delete my temporary queries for each even because that is what the example I found did. Should I not be doing that? Should I instead be creating a global temporary query and then leave it open until the application closes and just keep changing the...

A glitch! The my browser kept timing out while I was submitting it so I kept trying until it went through. I won't do that next time. Sorry about the inconvenience.

Hello All, I am doing a lot of temporary queries like this: Set PTQuery = db_Oracle.CreateQueryDef("qryTemp") I am deleting them w/n the same block of code when I am done with them. CurrentDb.QueryDefs.Delete "qryTemp" Sometimes the queries overlap so I have taken to appending a number on the...

Hello All, I am doing a lot of temporary queries like this: Set PTQuery = db_Oracle.CreateQueryDef("qryTemp") I am deleting them w/n the same block of code when I am done with them. CurrentDb.QueryDefs.Delete "qryTemp" Sometimes the queries overlap so I have taken to appending a number on the...

It is a pass-through to Oracle. Can I dynamically set the connection string based on input from a Login form?

Hello All, I am using the Form Wizard to create a form based on a Pass-Through Query, but it keeps prompting me for the password to the ODBC connection. Is there a way to cache the password? Or is this just not a good idea in general?

Hello All, I am using Access to build a front end to an Oracle 10g database. I have a table with 300,000+ records. I built a form over the table and it performs like a dog! Is there something I can do to improve this?

OK. I have figured out a work around to my issue. I added a button to display the data in a "pop-up" form and then I set the filter criteria and turn on the filter. Not what I wanted, but it works. But while I have been working on this I have noticed that the main form will suddenly change...

Yes, this is a composit key. The relationship between parent and child is identifying and actually has a foreign key constraint in the database. A little more clarity...Access is the front end and Oracle 10g is the backend, using ODBC to connect. Access "gaks" when I get to the third key pair...

I think I need to explain what I am trying to do. I am trying to manually keep a subform in sync because Access seems to be struggling with the fact that the there are five fields that have to be linked. I think I need to use the "On Current" event as that seems to be firing everytime I hit...

Hello All, I have a form that scrolls through the records in the table. When I click on the "Next" button for the next record what event or events, fires?

Hello All, I was wondering if it is possible to connect a MS Access front end to a MS SQL server on the internet in a secure way through ODBC or some other means. Anyone have any ideas? Thanks.

The actual SubFormControl name = [ObjectTableAttributeMapping subform1] So the On Current should be: FORMS!TableObjeMapping![ObjectTableAttributeMapping subform1].FORM!ParentTableAttrId=TableAttId Right?

RG, Here is my statement: Forms!TableObjeMapping![ObjectTableAttributeMapping subform].Form!ParentTableAttrId=[TableAttId] You said: So the mapping would be: FORMS!MainFormName = TableObjeMapping SubFormControlName = ParentTableAttrId So my statement should look like...

RG, Now it is telling me "Microsoft Office Access can't find the macro 'Forms!TableObjeMapping!ObjectTableAttributeMapping subform1.' Thanks.

RG, I am actually trying to set the value in one subform with the value from another subform. That is all the code. Expression Builder put the leading = in the On Current event. Thanks.