Search results

Hi, I'm trying to slim down some of the code I've got and have a process that is massivly repetative (the update line would drop from 20 lines *6 currencies =120 lines to just 2 lines..) What I'd like to do is replace the month number and the currency (GBP is this example) with a variable...

I have a report that picks up a date from a textbox and uses this date as its filter. However, it will only bring through the data is I turn the date into the American format of mm/dd/yy Everything in the system to the best of my knowledge is in the UK style of date. Can anyone advise on why...

I am now not sure if I am approaching this issue in the correct way. I have 3 tables, Swaps, Loans and Agreements To model the relationships, each table has a many to many relationship with the next (have no problems setting up the intermediary tables) but is not required, so no referential...

I've got a sub form that gets re-used on a number of forms. It is controlled by the same control (combobox) on each of the main forms. The sub form gets its data from a recordsource that is an sql statement. I can get it to work by naming the main form in the criteria (ie...

I have jsut been given a flat file that has come out of one of our other system that has come out in a mess. I have tidied it up to stage where it looks like Code --- Address 01 --- address1 01 --- address2 01 ---- town 02----address1 etc (The number of address lines can vary)...

On one of my data input forms, I allow the user to “copy” the details from the previous piece of input, which they can see, as well as the option to use combo boxes for example, they may select town and county from the previous input, but select a new road from a combo box. I can move the...

I am trying to find a way of securing my mdw,mdb and mde files in terms of preventing users from (perferably) seeing them and certainly being able to delete or rename them. I have tried restricting the access via folder level security, but prevented the users from being able to access the...

I've got a data entry form that contains a sub form to allow users to enter a quote. THe main form contains the "generic" information, whilst the sub form will allow them to add all the items that are being quoted for. Is it possible to have mulitple rows on an unbound form as I don’t want to...

I'm trying to write a procedure that will requery the combo boxes on any loaded forms to enable users to add a record, return to the original form and view the new data in the combo. As the input form can be called from a number of other forms, I can't name the form that needs requerying...

My IT dept have set the default for opening all MS packages to show the tip of the day on opening. They have removed the ability to turn it off. Is there a way of doing this in code as a part of a start up function?

I have a table that is overwritten every month, but want to keep a copy of the old table (in the BE) for audit. How can I control the BE from the FE and is it possible to create a link to the new table in code? Hope someone can help!