Search results

you missed the point. this technique will allow me to save a report as is and then have it saved in excel. if you save a report to excel you would get entirely different results. whats saved in excel is a query, not the report. i am just having problems with the vba part of excel. i am new to...

Hi I have some code and i don't know why sometimes i get errors, sometimes i can get parts of it to work. the objective: run a report, save it as a word document, then copy it on to the clipboard, and delete the file. then i want to start a new excel spreadsheet, paste my clipboard in it, and...

pono1 - adding adOpenKeyset helped. thanks bro, sam

you can use Dmax(Format(MyDate, "ddmm")) you may also need to use a CInt Funtion to covert the date to a number.

thanks guys, i will try "pono1" method. ruralguy - i think i tried that, but i didn't support the .movelast either. ( iwill try again). anybody know about the second question? should i use outlook automation instead? i think i read that somewhere. thanks, sam

Hi I read the help files a few times, and i don't understand why my recordcount in ado recordsets return -1. basically i run in to the problem of knowing whether the recordset has opened. what am i doing wrong? also, i would like to verify if the docmd.sendobject excuted. basically i send some...

why don't you use the TransferSpreadsheet Method ?

Ok, I don't think i will be able to give my full opinion on this, since it is friday and i am in a bit of a rush out of here. I will try to edit this post or add more in the upcoming days. I worked on a survey and i must caution you that they are horrifying. If you build a table that has a...

Thanks a lot. I would like to add that i asked around on the web, and everybody agrees that ActiveX controls should be avoided whenever possible. they have a lot of versioning problems. note, that the Date and Time Picker doesn't work on 2003 sp2. sam

Hi I use the Date and Time Picker. i know that i can get many other calendars, however, my theory is that i would rather use something that is directly supported by microsoft. but as i found out now that may not be the case. on of my users updated his Office 2003 after he was having problems...

this fixed my problem: Private Sub ModelNumber_AfterUpdate() RunCommand acCmdSaveRecord End Sub thanks all, have a great weekend. this groups rocks!!!!!!!!!!!! thank you all, sam

Ok, I found a solution, however i don't know how to put it in to code. please help. if i select my value from the pulldown menu, and select Record | Save Record on the access menu, then this error does not occur. i don't know how to write this. i would like to add this to the...

not sure how to do this. please explain. i just reviewed this problem again, and i see that it has something to do with the fact that its a pull down menu (model number). if make my selection, and i let the sub run, sub runs fine, however, i can hit Esc and the record is not saved. if i try...

the following is what i posted today on the Microsoft discussion board: Hi i am working on database which will keep track of all computers, servers, printers etc.. purchased. i created a table which has all the computer model numbers with all the specs as fields. i have an ordrer form which...

yeah, i just couldn't get it to work. i need to run my sub at exit, and then it just didn't save. i think you pinpointed the problem, i just don't know how to get around it. thanx again, sam

only in some scenerios it doesn't create the acomID. if you click on another record then there is no problem. the error only happens when creating a new record and clicking on the other fields of that record. in order to full understand the issue, the sub adds a record to the description table...

yup yup, if you review the zip file, actually a .mdb file, you will see that the sub is after the value is entered in a field, which should trigger the autonumber to automatically update. problem is, the entire record hasn't been finished. i don't know how to work around it. if you review the...

Hi I am attaching the relevant portion of a database which i developed. this is the scenrio: my computer purchaser wants to keep track of all his purchases, primarily computers. the order form has more details that are not shown. basically, the order form has the details as assets. assets can...

Hi i would like to link to a query. when i go to file | Get External Data | Link Tables, i don't see my queries. is this possible??? and if so how? sam

in the header and body of the report, you create text boxes that are named box1, box2 etc.. you then add to your code a for loop that will look like this: For intX = intColumnCount To intControlCount Me.Controls("Head" & intX).Visible = False Me.Controls("Col" &...