Search results for query: *

Hi all, I have a form that allows user to fill out 10 fields where one of them is autonumber. Is there anyway to retrieve that autonumber in the code? I need to do other database operations based on that number, but the number does not appear in the textbox (dataform) until I exit or scroll...

Hi all, I'm trying to link to a csv file on a website that requires authentication. I know that you can do it in Excel but don't know how to do it in MS Access, or is it even possible. Please help! thanks

Hi all, I'm trying to link to a csv file on a website that requires authentication. I know that you can do it in Excel but don't know how to do it in MS Access, or is it even possible. Please help! thanks

Hi all, What settings do I have to change to enable data editing in a select query? The select query joins 3 tables together and is displayed in a subform. I have made sure that the setting for uniquerecords on the query is set to No. is there anything else I should be doing? Thanks!!

Hi all, I have a function in SQL that stores a string that will be inserted into Word during mail merge. I would like to add a newline character into that function in SQL so that when it gets inserted during mail merge MS word will recognize the character. I have tried using CHAR(13) +...

Hi, I have just taken over a database from a person who has just left the company. He has set the permissions on that Access 2000 project that no users can modify the permissions to access tables, queries etc. I need to get in to give an user access to a report, but Tools -> Security -...

Hi, Is it possible to save an excel macro so that it can be used in other excel sheets? Would the export and import function work? I want to be able to run the same macro on many different files, and these files are data files created by another program, so there's no way to know what the file...

Hi all, I've been having problems with a simple excel query. What I want to do is to have this query done on an external data: SELECT TSC_Change_Request_v2.Status, TSC_Change_Request_v2.CR_ID, TSC_Change_Request_v2.Objective, TSC_Change_Request_v2.Planned_Start_Date__mm_dd_yy_...

Hi, I have a main form that needs several split windows. Which control should I use to create those split windows that will provide me with the scrollbar function? Each split window needs its own scrollbars. Right now, I have two frames (each frame has several textboxes) because there are so...

Hi, What does Transform do? I have this query that is giving me the wrong data, I just can't figure out what's wrong: i'm trying to figure out what's wrong with this query: TRANSFORM Sum(tblSource.[A Pax]) AS Pax SELECT tblQtrHrs.QtrHrTime, 'A' AS Bound FROM tblSource, tblQtrHrs WHERE ( (Not...

Hi, I have a parameter specified in a query, and i need to pass that in when i use the docmd.openQuery command, how do I pass in the parameter value? the value changes each time i need to open that query.

Hi, I have two tables table1 and table2, they have identical fields, but the data is different. I want to select 1 record each from table1 and table2 using two separate criteria (criteria for table1 is different than criteria for table2). After selecting those two records, I want to be able...

Hi, I need to find out all the records that do not qualify for an Inner join, how can I do that? I have a query that does the inner join and puts it into a table, but I need to know all the other records that have not been inserted into a table. Please help. thanks

Hi I'm trying to search for a record using the findnext method... and here is my code strSearch = "FLIGHT_NUMBER='0002' and AIRLINE_ID='ACA' AND BOUND='A' AND CITY_CODE1='YVR'" TerRec.FindFirst strSearch somehow the noMatch property is always true even though I know that the record exists...

Is there anyway to select a record from table A and insert it into table B without listing the field names? there are 30 fields, and it's such a pain to have to do that. I need to append to Table B, so I can't do select Into..... Please help... thanks

I have a lot of fields to retrieve from a database, however, everytime this procedure is run, the tables can be slightly different at times. If there is a field that i'm trying to extract does not exist in the recordset, how can I trap it and store the missing field name somewhere for reporting...

Hi, the focus is now on a text field. I want to change the focus to the form, but how do I reference to the form? what is the difference between a "!" and "."? I get confused between these two symbols for referencing. thanks

Hi, is there any easy way to check if a field name exists in a recordset without having to iterate through the entire list of field names? thanks very much

Hi, I have a list box that lists the tables inside another access database. I can obtain the path of that access database file, but how do I use the path so that the list box will display the tables?? Is it possible? thanks

Hi, I want to have a list box listing some of the database tables. Is there any way to list just some of the tables in the access database? thanks in advance