Search results for query: *

Hi all, I have imported a table from oracle to crystal reports, when i add my date field to my report the date is displayed in the format 01/01-4713, however when i browse to field data on the field, the correct data is displayed!! So I'm assuming perhaps i need a formula to format the date...

Hi all, I have a piece of code which i know works where by I insert a record into a new table. I want to now insert a group of records (whicch are displayed in a list box - all are selected by default) into the table but i am getting a Debug Error - Object required when I try to do this. This...

Hi all, I am currently trying to step through code for a Batch Job which moves files from one folder to another. I am getting the error "Object Variable or With Block Variable not set" on the following line: Set oTagAttributes = oNodeBirthDetails.Attributes If anyone has experienced this...

Hi all, I want to search through about 100 files for a specific string - "Country code is invalid" which is contained in the text of the file, these are xml files. I am familiar and have been using the FSO to move and copy files but i just cannot find the property/object to search for a string...

Hi all, I have a query where by the user can enter in a description to bring back a number of records, when they enter in a single letter (which brings back about 14000) records my database crashes. This is my search query: SELECT tblProducts.[Product No], tblProducts.Updated...

Hi all, I have a form based on a table which has the Product No (autonumber) as the PK. i ahve an update query which will update fields in my table as follows: Update tblproducts set primary_material_no = '" & Combo59.Value & "' , secondary_material_no = '" & Cbo_subcategory.Value & "'...

Hi all, I have a simple form which was created based on a table. On my form I have an updated yes/no field which is filled when the record is updated. I want make a no of fields invisible if the record has not been updated. I need to check if the record has been updated each time i change a...

Hi all, I have created an array which holds unique product nos of records i have updated in my db. i now want to select records from my db based on the data (product nos)in the array. I have: List42.RowSource = "Select * from tblProducts where Product No in '" & myarray & "'" but it is...

Hi all, I want to run a select statement which will bring me back all the records i have updated in my last update statement (to be displayed in a list box) how would i create a select statement to do this?? Or what would be the best approach to doing this?? Many thanks, Maggie "Work is the...

Hi all, I know there is a default vertical scroll bar for a list box with a long list of records so you can scroll down to view them all....however if i have loads of columns i want to display is there a way of setting up a horizontal scrollbar or a property to turn this on, where i can scroll...

Hi guys, I have a list box which displays the results of a search query: SELECT tblProducts.[Product No], tblProducts.[Item No], tblProducts.[Item Description 1], tblProducts.[Element Description], tblProducts.Updated FROM tblProducts WHERE (((tblProducts.[Element Description]) Like "*" &...

Hi all, I'm using the following code to UPDATE a record in my DB. Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim STRsQL As String Set db = CurrentDb Set qdf = db.QueryDefs("query1") STRsQL = "Update tblproducts set primary_material_no = '" & Combo59.Value & "' ...

Hi all, I have a log on form with a user name field and a masked password field. However every time I load my form the cursor is automatically placed 1 space away from the start of the text field in both fields.... is there a property i can change so that the cursor starts at the very start of...

Hi all, I created a splash screen form so that my user would open the DB and see the form only. In the Database start-up options I unchecked all the check boxes so that none of the menus would be visible. But now I want to get back to my main dtabase menu so I can edit my tables and forms...

Hi all, In my program I have a combo box based on Primary Product Categories where by the user can select a value, I want to fill a second combo box with fields based on the value selected in combo box (1) when i click a button i thought I could just put a sql statement in the rowsource...

hello all! On my form I have a button that runs a search query - I want to display the results of the query on my form for further manipulation on a listbox as oppose to the results coming up on a separate table not on the form. how can i do this?? Or can you guys think of a better way...

hello all! On my form I have a button that runs a search query - I want to display the results of the query on my form for my further manipulation on a listbox. how can i do this?? Or can you guys think of a better way?? cheers Maggie May