Search results

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...

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

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...

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?

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.

Hello All, If I want to select a row from subform A and a row from subform b and click a button and have the keys stored in another table what would be the best way to do that? Thanks.

Hello All, I am struggling with how to do this ( I am sure I am having a bit of a brain lapse). My form has two ids from two master tables (MstrTableA_Id & MstrTableB_Id). The two MstrTable Ids are tied together by a surrogate key to show that they are related. So I should be able to scroll...

Hello, I have a very long SQL statement that I want to assign to a variable, but Access keeps chocking on the length. Is there some way to define the String data type as bigger than 255 characters? Thanks.

Hello All, I have a continuous form that I want to sort/re-sort based on clicking a button in the header. One button is for sorting the records by Project Name and the other is sorting by Project Tracking Code. The form is based on an SQL Select statement. Here is the click event code for the...

Hello All, I recently added a couple cascading combo boxes to one of my forms and now the data from the underlying table that has already been entered does not show up unless I go in and reselect the options. Anyone have any ideas on how to fix this? Thanks,

Hello All, I was wondering if it is possible to invoke PHP from w/n Access and return the results from the function to a form? Thanks.

Hello All, I have the following DCOUNT statement: MsgBox "Item count found = " & DCount("[ItemID]", "tblItems", "[ItemID] = [ItemFnd]") Where ItemID = Primary Key on table tblItems ItemFnd = a long Integer variable that gets populated programatically, not from the form. It is internal to the...

OK, all, this is making me crazy. I am simply wanting to display the number of records in a table when some one clicks on a button. This just displays the msgbox w/o the record count. I am sure I am missing something simple. Any ideas? Thanks in advance. Craig...

Does anyone know of a good SQL tutorial for Access. I already have a decent understanding of SQL so what I am looking for is how to use SQL within Access. Any suggestions?

I am in the process of writing a scheduling application for a friend. One of his requirements is that the same resources can not be scheduled for more than one pick up at the same time. A resource is basically a "kit" made up of 1 or 2 drivers and a van. The schedule table has basically the...

Hello All, I have a subform that I want to display values other than the key field in. For example, One of the fields on the subform is location. It is a plain text box. It displays the value of 5645 instead of "334 Greenbriar Road". 5645 is the key value stored in the db, but that is not...

Hello All, Is there a way w/n Access to ping GPS units out in the field and retrieve their coordinates and store them in the database? Also, any thoughts on the necessary hardware? This is all new stuff to me. Thanks,