Search results

Hi access experts I would like to automate the following function available in Outlook using a button on an access form: - User specifies folder and press button to: - Export emails to Access table - I would like to maintain the default map - Create a new table Please help - Im way behind on...

Dear All I have expereince in VBA Excel. I also run an estate agents, I am stuck in a loop of inputting lots of data manually to my spreadsheet from client emails. I recieve automated emails (fixed template) from verious website portals containing client details. We are talking about...

Hi I have a number of forms which the user can navigate through. On leaving a form some code is executed. My prblm: sometimes the application will freeze and not allow any control. I have to ctrl-alt-del. I have not used the echo command - could it be to do with setting focus to an object...

HI I have a list box which sometimes needs extensive scrolling to the right to see other data. Im wondering whether I can freeze the first few columns (key info) so I can trace the other data when scrolling. (i.e. like in an Excel spreadsheet) any suggestions please or code tricks?

HI I have a list box which sometimes needs extensive scrolling to the right to see other data. Im wondering whether I can freeze the first few columns (key info) so I can trace the other data when scrolling. (i.e. like in an Excel spreadsheet) I dont mind what coding if I have to - any...

Hi I have a form with two graphs, when i close this form to open another the speed is very slow. the form displays the action 'calculating....' i believe its because of the graph - the only object with data attached. The graphs rowsource is updated using vb. The rowsource is intially set to a...

Hi Has anyone got a usable or demo version of an off-line EPOS and stock control system. Its for an academic project - i need some ideas. It would ideally be used for a small shop selling a number of products. Transactions can be calculated and stored, purchase orders stored etc. Ive...

Hi I have been using the following code to open an Excel file. I wish to open a Word document - can i siply adjust this code? Ive tried but no luck... rgrds Set oapp = CreateObject("Excel.Application") oapp.visible = true Set wb = oapp.Workbooks.Open("C:\imports\testfile.xls") set ws =...

Hi I have set some start-up properties for my access application. I am trying to eliminate ALL access tools bars.. my application runs in a run-time environment - do i need to create extra vb code to remove the default tool bar: (Menu Bar) ?? regrds

Hi I am using the deployment wizard to package the Access application in a run-time version. I worked through a test-run of the wizard and installed the application on another machine. I noticed that when the user selectes the access help buttons on the packaged application - no help...

Hi I have developed a form - with a text box for the user to input a character string.. e.g. "productZ" or "038482" I am hoping to requery a list of records using the user search criteria.. Because the user will not always enter the exact character string - im thinking of basing the...

Hi I developed a database with some forms in access 2002 I have just upgraded to Access 2003 - Im having problems with all my tab controls - if i select one page, then another, and another... whether im in design view or form view the tab controls get messy.. what do i mean by messy...

Hi I wish to package my database and deploy on a cd - as a runtime envionment - I have compiled the vb code and converted the file to accesss 2002 and as an MDE file - I have read some logs about using the 'package and deploment wizard'. I have an office suite with Access, Word, Excel...

Hi Im trying to create an .mde file from a database that appears to be in an Access 2000 file format. I get a message - saying convert to Access 2002.. Will this effect any of my vb code?? ?? rgrds

Hi I have used some code to export a query to a spreadsheet... For some reason i get the error msg "too many fields defined". I understand there is max number of columns for a spreadsheet - however, the data being exported does fit easily into a spreadsheet. (when pasted) ??? rgrds

Hi I have a list box which displays sales figures - the data has been transformed into a more user-friendly layout using sql in a complicated vb process. On the same form i wish to create a button which the user can press to export the listbox data/layout onto a spreadsheet. Im hoping...

hI I wish to convert my database into a an mde file. I belive this removes all of the tables/source code etc. I would then like to distribute the database on a CD. I want the database to run like a program - so it can be installed onto a computer with a shortcut. I have created the...

Hi I have a peice of code i use to import a .csv spreadsheet. doCmd.TransferText acImportDelim, "DailySpec", "c:\myfolder\import\daily_a.csv", False, "" The drive letter C:\ may sometimes change according to the user specification My module gets the specified letter - how...

Hi A customer wishes to but a database - i am hoping to have a contract in place which will protect the software from being shared between unlicenced users etc... Has anyone got an example contract which i could maybe use to get some ideas??? This will be a big help - thanks you! Rgrds

Hi Please help - this is really frustrating me.... I have two forms - one form contains quite a bit of code attached to a button (on click event) I have now produced another form - I want to run the same code as the event on-click in the original form I have normally called procedures...