Search results

hi Mr.D., you could use instr(1,chr(45),MyField) and nest this into a Mid, Left right or whatever. Then have an Update query that will stick the two parts into 2 fields. For example Left(MyField, (InStr(1, MyField, Chr(45))) - 1) etc regards Drew

in the properties of the section is an option of "Force New Page" you can set this to None, Before Section, After Section or Before and After depending on what you want HTH Drew

Many thanks Denny, works perfectly Drew

Hi, after importing text files into a table with a function I want the function to delete any error table that may have been generated. The way I'm doing this at present is to count the tabledefs before and after the import and then delete xxx_ImportErrors if the count is higher afterwards. Is...

Hi, this may be really easy but ... I have a combo box with 2 columns, the first of which is 0 width, so only the second is visible. How do I get a default value ( such as "Please choose a...") to show in the second column? Many thanks Drew

i thought that something like Let Me!txtX.DefaultValue = 99 DoCmd.Close acForm, "form2", acSaveYes would work, but it doesn't. The only way to do it may be with a lookup table.

Many thanks, I look forward to it Drew

Usually it's because the page is too wide. if you go into design is there an area at the right that has no boxes etc in it? if so grab hold of the edge and drag it as far back as you can. Otherwise, sometimes lines are too long ( often hidden at the top or bottom of sections and tricky to get...

could you just post it instead!!! thanks Mr Hicks, I've done some code to do this myself but am less than convinced that it's the best way and could *definitely* use a better version many thanks RDH Drew [This message has been edited by KDg (edited 02-29-2000).]

This may just be me being lazy and not looking for it but... is there an easy way to create a menubar option or whatever that will only print the current page of a report on a screen. It doesn't need the option of multiple copies, one will do many thanks for your help Drew

hi fdco, i guess you've got your UPDATE and SELECT sorted so all you need to do is: create recordset from query ( rst ) do until rst.eof ' update query bit rst.movenext loop this will drop out at the last record. NOTE - it's not very quick if there's a lot of records...

it's that you're using Write rather than Print. Write will output as typed whereas Print will leave out your "". Put allows you to write to a particular place in a file - update existing records etc - if you need this then it shouldn't put any binary in front, if you don't state where the data...

you need to change textbox to whatever the name of your text box is. eg if it's called txtDate then you would have me!txtDate.value=Date if it's called Text0 then the code will be me!Text0.value=Date and so on - you need to check the name in properties, HTH

the best way I've found is to create a data import spec in the advanced section of the import table wizard. i then did a function to import as I have up to 50 files, the entire code is below. Please post back if you need any further help, Function succImportData(strTlName As String) As...

how did you stop them running DELETE, INSERT etc? or is that done by checking the string once entered? thanks Drew

it is available on text boxes, buttons etc. for example Private Sub Command0_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me!Text0.BackColor = 1974 me!text0.value=MyVar End Sub on moving the mouse over the box the above 2 events ( background colour...

It should do - post your code

If you're happy with the data being input by your clerk ( no nulls, garbage etc). I'd create an Unbound text box on the form ( just drop one on and it will be as the default) and do some code in the background. This is probably a bit beyond total newbie but if you need more just post back...

Have you tried 3 queries? 1/ counting "material produced or purchased" 2/ counting "materials sold" and then 3/ doing the maths you need if you base your form on 3 it should work, otherwise you're off into VBA and unbound boxes HTH Drew - apologies for the undbound boxes, forgot I was in...

If you're doing it as on entry after another then you could create a public variabel and store the value of the last entry in it. Otherwise you'd need some sort of "find the last record and dump it in" kind of thing. As in creating a recordset, going EOF and reading it into your form