Search results

Tried the space, still get the syntax error. Tried quite a few permentations now and the closest i got was for it to open the form but no fields or objects were shown apart from a counter in the forms header. There must be a way to do this!!!! Talk about frustrating :( Matt

Hi, Just tried your suggestions and get an error saying "missing operator in query expression" Have entered the following: stLinkCriteria = "[Top Level Assy No]Like " & Me![Text31] & "*" DoCmd.OpenForm stDocName, , , stLinkCriteria (The text box has a different name due to placing...

Thanks Pat and Harry, Will try these out. Been bugging me for a while now so hopefully your answers will be okay. Matt

Hi all, I am trying to get the following expression to pull a record into a form if only part of the data is entered i.e. if 123 was entered and there are records called 123456 then this would be displayed. i cant seem to get the mask right. here is the code which works with exact criteria...

Thanks cogent1 for your speedy reply. Matt

Hi all, Wonder if anyone could answer this: I would like to be able to open a form which is data entry only using a command button BUT not actually creating a new form with its properties set to data entry only. Is there some VBA that i can use to do this to place behind the button? thanks Matt

Thanks dgoulston for your input on this Okay you guys have convinced me, i'll change the option groups to toggle yes/no buttons. I am about to code this up so ill post here if all went well. cheers Matt

re: That sounds very feasible. :) i have now finished work for the day but will pick this up first thing in the morning. thanks for the advice, i will let you know how i got on. Matt

Re: Option groups I can now see where you are coming from, i suppose i could have used the yes/no Check Boxes for this but just decided on using the option groups instead. I normally do things the hard way! :rolleyes: I have 6 option frames on one form. Do you have an answer on this? Matt

Re: Option groups The option groups give me a quick an easy way of letting the user input an answer if the particular task has been completed. The value is then stored and triggers actions off further down the line. What would you suggest i use instead of option groups, just the actual option...

Hi all, Can anyone help me with this: I have six option frames on a page which when selected need to trigger one text box to say either "Completed" or "Outstanding". Ie if all of the frames were clicked over to the Yes position giving a value of "1" then the text box on the previous screen...

Thanks Matt

Is it possible to add a prefix to the autonumnber. I have tried but failed. I would like to be able to place the following prefix: CN To a autonumber field. Any help appreciated Matt

Pat, Thanks for your reply, though i am still unsure, if the recordset has been built what is it calculating when you click lets say the next record button(it starts calculating again) is it pulling the next record out from the record set or is it re-querying the the backend table again which...

I fully understand the concepts of SQL and how to query databases but this has sort of been bugging me for a while... I have a frontend and a backend databases which are linked, When i load up a particular form which has a query attached to it, the query obviously queries the tables and returns...

Thanks Rich, Sometimes its the obvious ones which are hard to work out. Thanks again Matt

I need a little help on this one.. I have a report which lists out purchase orders. What i would like to do is each purchase order line to have a incrementing number against it.i.e 1 something 2 something else etc etc The report data is fed through a...

I have a purchase order (purchasing dept)form which recieves orders from other purchase order input forms through a query.I am trying to get the form to refresh data or even flag up when a new purchase order is created and sent to it. Can this be done when the form is opened? and if so what...

Thanks dhoffman and sfarr, I will give this a go and let you know how i get on with it. Matt

I am trying to create a report where the user can enter 5 "from" and "to" dates and then the data would be listed in the report across all of these date ranges.The date ranges are various weeks in a month ie 01/08/00 to 07/08/00. I am trying to get the report to list the data in 5 separate...