Search results for query: *

Hi All. I'm working in excel 2003 and want it to work a little like Access. What I have is two worksheets, the first is similar to a form, displaying a single record. The second worksheet is the table with many records (each with a unique number for reference). What I after is a method of...

Hi Everyone. I'm having a little problem trying to set the height of the page header of a report. I'm using textboxs with cangrow on in the report header with no problem then I'm repeating some of the same boxes in the page header (for the 2nd page). I've found out you can't adjust the header...

Hi all. Im just stating with Visual basic 2008, downloaded the express edition off net. Done a bit of VBA in access before but new to VB2008. My problem: I've created a from (form1) and added some buttons and a text box. No code just wanted to get it looking something like first. Did a...

Hi All I've got a form with a textbox with unbound text. I want to create a small jpeg file of the text in the textbox. Text will vary in length. Any ideas Thanks Mick

Hello all In Excel is there any way of printing several rows at the bottom of a page. I know it can be done at the top using page setup, but I want to repeat at the bottom as well. Thanks Mick

Hello all I'm creating a recordset in access2000 and I'm having a problem starting it. The code I'm using is Dim dbmydb As Database Dim rsmyRS As Recordset Set dbmydb = CurrentDb Set rsmyRS = dbmydb.OpenRecordset("QRY Email select") I tried to sort the problem by writing the code in access97...

Hi all I've got a continuous form in which i am recording percentage values. In the form footer I've got a textbox calulating the total percentage using =Sum([Percentage]) in the control source. when I update the percentage values I requery the total percentage, no problem. What I...

Hi all I know this sounds stupid but I cann't turn off the border I've put on a report. All the other controls on the report have borders set to transparent and don't show but the listbox still prints with the border. I've even changed the border colour to white with no change. Any ideas...

Hello all I'm trying to get a picture in a database so I can see on my form without bloating the database. This is what I have: 1st I have a folder called photos 2nd a table with one record, this being the path of the folder (save people going into the code to change it) 3rd a frame...

Hi All I've got a combo box where I'm selecting a suppliers name and storing the supplier-number in the table. I've got the combo set to "limit to list" and the headings are supplier number; supplier name width 0; width 4 when I enter a suppliers name that isn't in the list I run...

Hi all. I've got a list of suppliers and a related table for the projects each supplier works on i.e. Supplier 1 project1 project2 Supplier 2 project1 project3 On a form I've got 2 combo box & other controls. The first combo box you select the project...

Hi All I've got a form to list customers / suppliers, usual stuff company name, address etc. Then I've got a subform which lists all project associated with each company. On the subform there is an unbound combo box, to pick from a list projects and then update the other project details /...

Hi all Just added a listbox to a form and the data shown has a black background, (as if its has the focus, but it hasn't) how do I make it look like any other text box with black text and a white background? I'm using a listbox as I'm looking up data from another table.

Hi all I've been using Acc 97 for a while now but just about to develop a new database that needs off site access. What I was thinking was developing the database for internal use using forms & reports as per acc 97 so nothing new there. But what I want to do and this is my question; can you...

Hi I've been asked to have a look at an old database developed by somebody a lot smarter than me. Anyway the problem I have is, The autoexec macro falls over when the Runcode calls a Function called "start_db()". Access cannot find it. It's hid away in a module called "mdl_start" with lots...

Hi I'm writing some instruction that include screen shots. I'm pressing print screen to get a screen dump but the mouse is not shown. Any idea how to resolve this. Thanks Mick

Hi I've created a macro that opens workbooks, these workbooks have links to other workbooks. What code do I use to set the lookup value to yes and prevent excel from asking me the question 'Do you want to update links' Thanks Mick

Hi all I've got a excel spreadsheet which I want to add a button / macro to open the print dialog window, I don't want to print the document just open the dialog box to select the printer. Any ideas?? Thanks Mick

Hi all I've got a combobox on a subform which looks updata and updates fields. ie combo orderno(unbound) orderno (bound) partno (bound) I've set the combo to "limit to list", when new data is not in the list opens new form to enter data...

Hi I've got a combo box on a subform which selects a "build activity" from a list (limited to list). What I want to happen is that after I've entered the first record on the subform the next record defaults to the selected "build activity" selected in the first record...