Search results

OK, The picture does not come up because it is not in the detail section. BUT!! The problem is that there is a subform bit that goes with this report also how can i get that to display .. is it just a case of adding in a subform as you do on forms??

In the report there is a linked image .. but i can't get it to display. In the form the image displays fine but as soon as i go into the report it thinks about it and appears to load the image but it is not visible. Any help will be really appreciated ... I have attached the file because i...

Erm I can't seem to get that to work. Here is what i have. In a module i have Public Sub setID() Public IDLetter As String IDLetter = "A" End Sub In a macro called autoexec i have Runcode ..... SetID That is all there is. I get an error that says invalid outside procedure as it tries to...

Hi there I am sure that i am just having a daft Friday problems but ... I am declaring a public variable in a module eg Public IDLetter As String and i want to set it to a value when the database starts. How can i do that? At the moment i am setting it on a form open. Is there a different...

Sounds good in theory. I'll give it a go and see what happens. Steve

They are all on different networks unfortunately. The sub forms are both on the main form and are both 1 to many. I am beginning to think that i need to create my own unique ID for each form using a prefix of my own for each table. Then they should link in fine. Does that sound like it will...

I have just inherited a database to sort out and it is a nightmare like all inherited databases. This database is going to be e-mailed out to several users. Each user will put data in to it and then send it back. In effect there will be 20 copies of this database. The problem begins here: I...

you can use a macro to do the same thing if it is easier for you. ust the outputTo it is fairly self explanitory after that. Steve

You will need to create a cmd button and use the following code DoCmd.OutputTo acForm, "Form2", "Microsoft Excel (*.xls)", "c:\fred.xls", True, "" think that should work but not sure Steve

CAn you not just set the ColumnWidth = 0 That should do what you want. Steve

I also came across this problem whilst doing a database for the NHS ... would love to know if there is an elegant solution. What i did was created an array of bound hidden check boxes and then made one of them check if the corresponding thing on the list box was highlighted. Then on current...

I tend to use a grren sort of colour. 10018472 Steve

Thanks dcx693 that is exactly what i needed. :D Steve :D

I am using Access 97 and DAO i think.

I have a list box and i want it to act like a combobox in the sense that i want to be able to add data to it. (As in notinlist sort of thing) I have a textbox so that the user can type in something and then click a button and add it to the list box. The listbox is unbound and the row source...

try. This Steve

Could someone convert that database to access 97 and repost it for me as i only have 97 please. Steve

DoCmd.OpenTable "Table Name" Steve

what do you have in the on open event?

DoCmd.Hourglass True DoCmd.Hourglass False Seem to work fine for me.