Search results for query: *

.AddObject('lblID'+ALLTRIM(STR(thisform.branchcount)),'label') theCmd = ".lblID" + ALLTRIM(STR(thisform.branchcount)) &theCmd.caption = curbranch.Branch_Num &theCmd.width = 100 &theCmd.top = 60 + ((thisform.branchcount - 1) * 40) &theCmd.left = 10 this is my code embedded in a loop to try and...

I may be trying to use the wrong control here and if so please let me know. What I am trying to do is this. I need to manually populate a grid with values for the user to make some choices. I dont have the data in a recordset or anything, but I like the format of the grid for this purpose...

I have a grid control with three columne that I am populating from an sql statement. I have the RecordSourceType set to 4 = SQL and this automatically sets the grid to read only. The problem I have is that I am populating columns 1 & 2 from that source and a combo box in the third column from...

I have jumped into a project midstream and am having some issues trying to modify this project that I don't think should be problems at all. On this one form I have an input box (class Fhtextbox) DOB that is date formatted with the '/'s pre-entered into the box so that the user only has to...

What I am trying to accomplish is to open an adobe file for the selected client so that the user can scan in information or whatever they want to do with this adobe file. What I have is this from poking around on this forum. myPath = "\Data\charts\" + str(chart.key) + ".pdf" myResult =...

I am using reference to Excel 10.0 library. code xlSheet.Range("A2").NumberFormat = "#,##0.00" does not change the formatting of the cell. I had expected it to change it to a custom format but it did not. 4 still displayed as 4, not 4.00. Actually what I am needing is to set to Number with 2...

OK, What I want to do is this. I have a column, call it A that has random numbers as unique identifiers and say they stop at 1000. (0-1000) I want to write a button_click method to choose say 25 of them randomly, uniquely and print out a list. Can this be done?? If the printing is a problem...

I am writeing code in a module that is tied to a switchboard button that will open two forms and automatically print those forms then close them. I can open them, and close them but I can't seem to find a way to print them out. I tried putting code in the f0rm_load of the forms and sending...

I am trying to update a user defined menu macro. This menu functions properly but my boss wants to be able to use the "window" menu that is built in to Access as well as these new ones on this particular form. Is there any way to have built_in menus accessed through the addmenu...

I am trying to use an SQl querry in VBA to obtain the max date from a group of records and then use that to open a form with only the record that had the right ID and Date. I have the correct information but when I use the docmd.OpenForm method in Access and try to use date = rec!date in the...