Search results for query: *

Can anyone help, I have just been sent a database, and I can't use the right mouse button to bring up any menus. I'm guessing this is a setting within the database(It's occuring for all areas not just on forms). Does anybody know how to reset this setting or even give me an idea on where to...

Does anyone know if it is possible to pause VBA code while a User completes a form?? or does anyone know a way to use a combo box on a VBA control? The situation I`m in is that when a user chooses an option form the main menu I need a prompt/form to make them choose their name from a list...

I'm creating a form in Excel and need to populate a ListBox with the results from an Access Query. Can anyone show me how to set this query as the control source or populate it in a nother way? Thanks Ian

Hi, Hopefully someone can help me out on this one :) I have a number of linked tables within my front end database linking directly to the backend. What I need/want to do is to change though VBA the database path for each of these linked tables so they all point to a new folder path for the...

Hi, Is there a way to retreive the size of an array after it`s been declared? E.g dim QueryList(67) as Variant I wish to retreive later on in the code the value '67' or equivilent at the time as this size is subject to change. Thanks Ian

Hi, Hopefully can help and knows a way to improve the efficiency of this method. The Problem. ------------- I am importing a data from a delimited text file. Due to the format of the data I have been forced to do this completely through VBA writing each record individually. This is fine...

Hi, Can someone help at all with this problem. Below is a bit of code I`m using to add a new record to a table. What I am trying to do is cycle through each field I wish to add data to with out actually naming it in this part of the code. The problem Ive got is I cant get the coding...

Hi, Can someone help at all with this problem. Below is a bit of code I`m using to add a new record to a table. What I am trying to do is cycle through each field I wish to add data to with out actually naming it in this part of the code. The problem Ive got is I cant get the coding...

Hi, Not sure if this is the correct area for this question but doesn`t fit anywhere so here goes. I have just split a database to a front end Back end style using linked tables to join the two ends together. This has now fallen over on the daily importation of text files. For some reason I...

Hi, Not sure if this is the correct area for this question but doesn`t fit anywhere so here goes. I have just split a database to a front end Back end style using linked tables to join the two ends together. This has now fallen over on the daily importation of text files. For some reason I...

Hi, I`m trying to find some code that will allow a user to navigate through folders and when at the desired location will return that path for use in the future. I know there is code etc to do this but am unable to track it down. Can anyone plz help. Thanks in advance Ian

Hi, Can anyone help me with sending an E-Mail directly from Access through Outlook. I`m currently using Access 97 and Outlook 98. I`ve tried the Sendobject command but don`t know how to go about letting the system know what to use as the mail system. Any help would be welcome. I know theres...

Hi, I need to open a word document as read only through a shortcut. Does anyone know the command line I need to use. I`ve currently got the line setup as "c:\word.exe" "C:\wordDoc.doc" What parameter and where do I place it to make the file open as read-Only? Thanks in...

Hi, Hopefully somebody can provide a solution to my dilemma. I have two different applications running, one is notepad and one is a specialized program. My aim is to copy data from the teh specialized program into notepad to use at a later date. I am using the SendKeys command to basically...

Hi, Anyone know how to adjust the window height within coding? I have my Detail section of my form set to invisible at load up. The user then chooses the record they wish to view from the form and the detail section is then set to visible. What I need to do is then change the height of the...

Anyone, My problem is with saving a creating record within a Subform. The current situatuion is this: I populate information within the main form to start with. Then on the press of a command button some of this data is used to create a record within a subform. The problem lies in that I...

Hi, I`m creating a text file, using a number of string variables as the source information. Does anyone know how I can get the "" surrounding each output line to be omitted when writing to the text file. I have used the following method to create and populate the text file...

Anyone, I have a form/Report linked to a combobox which filters the results produced. My problem is that the combo source is coming from the main table and produces a list of all the departments in the table. I require also to be able to produce the report with all the departments and not...

Hi I am trying to find the Details of a shell Procedure that I wish to Call from Within Access. I can`t remember the name of the Procedure but the end result I require is for the user to have the ability to navigate through the filesystem and be able to chose a single file. I will then only...

Hi I am trying to find the Details of a shell Procedure that I wish to Call from Within Access. I can`t remember the name of the Procedure but the end result I require is for the user to have the ability to navigate through the filesystem and be able to chose a single file. I will then only...