Search results

hi, I'm having a big problem with bookmarks. I've just upgraded an access 97 backend to sqlserver 7 and the .bookmark = .lastmodified has started giving me the previously modified record rather than the one i just added. this caused major problems where reports were being saved to the wrong...

Hi Jon, Thanks - memo fields are indeed the problem. I've tried all sorts but finally had to work around it by putting one field in the footer. Tried your suggestion but no go. It's not ideal but it will do I think. thanks for your help cheers bob

Hi, I'm exporting a report to Word and am finding the fields are merging/overlapping. I have 4 fields which can grow in the report header -they are fine in the report but are a mess in Word. Can anyone help? thanks in advance bob

Hi, Put a query behind the report if you don't already have one. Then in the criteria of serial_number put a reference to the serial_number on your form. You could filter the report but it's more reliable to use a query cheers bob

Hi, If you hve an ID number on the screen you can reference it in the query behind the report. eg in the criteria put like forms!yourform!ID This will just print the record on screen cheers bob

Hi, Just wrap the wildcard around your number ie. strSQL = strSQL & " WHERE [tbl-BOX].[Ser No] Like " & "*" & Number & "*" cheers bob

Hi, No your not stupid - that's the way to do it! bob

Hi, I thought you wanted to change the recordsource of the "whole" subform. You can reference the subform controlsource from the master form using this code. forms!mainform.form!subform!recordsource ="query" You can populate it with SQL or just a query name as above. bob [This message has...

hi, Yes you can go below 8 points by typing in a number directly into the points combo box. You can be creative with reports using groupings, sorts and subreports. You could group by date for example. You can also have more than one column in a report so you could have 2 columns of 7 days...

Hi, The syntax to refer to a subform is:- Forms!mainform.Form!subform!field so to set the recordsource it would be forms!mainform.form!subform!recordsource ="query" cheers bob [This message has been edited by bob makepeace (edited 03-15-2001).]

Hi, You can only use the like operator on text fields so you need to convert the ordnum_28 field to a string.ie. UnitPrice: IIf(cstr([SO Detail]![ORDNUM_28]) Like "5*",0,[SO Detail]![PRICE_28]) bob

Hi, Your movie names table should have an index. Create the combo putting the index and the movie name in a query behind it. Then select the bound column as column 1 and show 2 columns, hiding the first so you just see the movie names. To add a new one to the list use something like the...

Hi, You can use ACCESS like VB. If you open the recordset you can populate a screen by setting the unbound fields to the fields in your recordset. You can scroll through records by doing a .movenext etc and re populate the screen. It's a good method if you want full contol of the screen...

Hi, There are several ways to do this. Probably the easiest is to build in the criteria in the query underlying the screen. If you default the combo boxes to null and pop the code below into a module all you'll need to do is requery the form whenever a combo box is chosen. Public Function...

Hi, If the field you want to automatically add is in the main form, you could reference it as the default value of the field in the sub form. eg =forms!formname!mainfield hope this helps bob (great minds! :-)) [This message has been edited by bob makepeace (edited 10-12-2000).]

Hi, What was the error message? bob

Hi, Thanks David. It looks like we will be able to keep this particular senior manager happy by using an ISDN line. The system is then just as quick as over the network. Thanks for the advice though, I'll bear it in mind in future. best regards bob

Hi, Thanks. It's worth thinking about. I've managed to cut login time down to 6 minuites - I'll just have to wait and see if this senior manager wants to escalate things. We may have to move to a SQL server back end just to keep him happy! thanks a lot for all your suggestions best regards...

Hi, Thanks, I'll look into the arrays idea. Re emailing data, the system has been live 6 months now and it would be too big a change I'm afraid. There isn't a great deal of data being brought down to the PC, it only takes about 10 seconds to log on over the network. Trouble it takes 10...

Hi, No, I'm connecting to an access database and bringing down a selection of data using recordsets. Linked tables don't work with 100+ users and certainly not over a telephone link I'm afraid. I tried using SQL for external databases but that's even slower. The system is very quick, even...