Search results

I finally got my query to work, but I have one other obstical to get around. The rnd() does not generate a unique random number for each record. The random number ends up being the same for each record that it is joined to. Does anyone know of another way that I can create a unique ID for my...

Is is possible to concatenate date with other data in a query? For an example would something like this work? INSERT INTO tblCompany (CompNum & rnd(), field1, field2, ....) [This message has been edited by crhodus (edited 10-30-2001).] [This message has been edited by crhodus (edited...

I'm trying to figure out how to transfer data from one record to another in my database. I've got a table named tblCompany. My Primary Key is CompanyNumber. What I would like to do is have the user select a company and transfer all of this data, except the CompanyNumber, to another company...

Found a way to have window close automatically. I went to the properites of the msdos window and selected "Close on Exit". This seems to have done the trick.

Is ther a way to close a MSDos window using a macro or vba code in Access? I have a macro that uses pkzip to zip a file and I would like to be able to close the MSDos window when it is finished ziping up a database. Thanks!

Thanks! That fixed my problem.

How can I get my form to display records in datasheet view? When I launch the form from my switchboard, it loads it in Form View. I tried changing the Default View and Views allowed to Datasheet View, but this didn't help. Thanks!

Hi Pat, I checked to see if there were any tables that did not relate, like you said and I saw where either I or Access joined two tables in my query that should not have been joined together. Thanks!

I know this is something simple that I am overlooking and I've corrected this problem before with other reports in the pas, but I gone totally blank. The detail section of my report will display the Company Name. Also in the detail section is a subreport that contains DestCity, OverNight, and...

Never mind. I finally figured out what is happening.

I'm having problems with one of my forms. I've tried deleting the filter from the form and then saving it. But everytime I cloe the form and then view it again in design mode, the filter is still there. Any suggestions?

I formatted the code that you posted a little I've gotten the form to put the counties, selected from the list box, into strWhere so that it will display them in this format: 'Pike', 'Montgomery', 'Smith' For the SQL statement in my report, I have WHERE (((MCStop.STWCName) In (" & strWhere...

Thanks for your help! Whenever I click on my button, I get a Run-Time Error '3075' Syntax error (missing operator)in query expression. The error occures in this line of code: DoCmd.OpenReport "rptCenter", , , strWhere I think that I don't have the query that is in the report rptCenter...

I've been searching on the forum, but I'm still not sure what I need to do. First of all, I created a list box that gets it data from one of my tables. I set the multi select property to Extended. This part works correctly. I want the user to be able to select multiple counties from the list...

Thanks! I'll look into it.

I have a fild that on my report that contains a company number. Is there any way I can modify this field to look up the company name that is associated with this company number, so that it will display the company name instead of the company number? Hope this make sense. Thanks!

I have a button, named cmdRemoveFilter, on my form that, when clicked, will remove the filter from the form. Currently, the button cmdRemoveFilter is disabled. How can I have the button cmdRemoveFilter enabled whenever my form, frmCompInfo, is in filter mode and then disabled whenever the...

Thanks. I tried doing what you recomended, but I ended up adding the following line of code: WHERE COMPANY_NUMBER IN (SELECT [tblCompNum1].[COMPANY_NUMBER] FROM tblCompNum1); This seems to have worked. Thanks again!

Actually, I want it to replace these records every time it runs. The records in the table are only temporary records. Regardless, thanks for your comments! [This message has been edited by crhodus (edited 09-11-2001).]

I'm trying to create a query that will dump data from table COMPANY_T, into another table NAMED tblCompany1, if any of the companies from COMPANY_T have their company number recorded in table tblCompNum1. Can someone tell me what I'm doing wrong? Thanks! SELECT [Company_T].[COMPANY_NUMBER]...