Search results for query: *

TheAceMan1, Sorry I meant there are 10 fields for the user to fill but autonumber is not entered by the user. I don't think I can retrieve the number before the record is saved. So I tried saving the record using : DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70...

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

Thank you very much!

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

OK, I thought if I got the network security people to get me the previous admin's login I would be able to change the permission, but now I have it, and Security -> Workgroup Administrator still doesn't show up. I can't find the .mdw file anywhere, should I be creating a new database and...

I see, thanks very much though.

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 Skip, I did try to edit the query without saving, but everytime I hit the exclamation mark to run the query, and I go back to the SQL query window, the query would be changed. And as you can see in the query I pasted in (the 2nd part), the parameter date value that I entered would be "?"...

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

i need to use the result from the 2nd part (the running total) to plot a chart...so i think i'll need to use SQL instead of the report.. here is the query: TRANSFORM Sum(tblSource.[A Pax]) AS Pax SELECT tblQtrHrs.QtrHrTime, 'A' AS Bound FROM tblSource, tblQtrHrs WHERE ((Not...

I don't get it. A report? The result from the first part is in a query right now. So I just have a table with two columns. How do I use the textbox?

yeah, i'm counting the passenger numbers within a time slot... tblQtrHrs contains just a list of time slot of a 24 hr period ...so it goes like this 0:00 0:15 0:30 0:45 1:00 ....and so on I've actually just solved the problem with the time slot....so it is now giving me correct numbers... but...

I've tried to do that...but it's still not doing what i want it to do:...this query was written by someone else, and I don't know who that person is, I've just been told to fix it so here is what i'm trying to do: I am given a schedule of flights, each record has both arrival and departure...

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

thanks so much everyone.