Search results

Hi All I have a very simple database (just three tables), which I have designed using Access, together with a simple input form with a few buttons and drop downs. Is it possible to convert the who thing to Excel (in particular, the form), and continue its development using Excel VB? The...

I have a number of macro's, each of which initiate a saved import. The saved import looks for a specific file in a specific location. This works fine the first time I run it, but each week a new file has to be saved, named exactly as the saved import is configured, but when I run the macro, I...

Hi All I have inserted a function via a module at the beginning of a Macro using the RunCode action: Function Msgbox_Yes_No() Dim Response As Integer Response = MsgBox(prompt:="Select 'Yes' or 'No'.", Buttons:=vbYesNo) If Response <> vbYes Then End If End Function However, it doesnt stop...

Hi All I have developed a system where three separate lots of data are imported and compared in a query. There is a unique code contained within each import, which is the key field that relates all three sources. However I want to see data returned where for example this unique code and...

Hi All I'm a relative newbie to the world of VB, and I've written the following code, to delete the contents of multiple tables. The trouble is, if the user says No to the Y/N message, it still deletes the contents. What is missing so that it abandons the process if N is chosen, and another...

Hi All I have created a simple switchboard form, which I have made a Pop Up = Y, Modal = N. I've added a few buttons, got rid of the scroll bars but still allowed it to have a min/max and close down button. One of the buttons generates a report, but the form itself has to be minimized or...

Hi All I am using the following formula to strip out certain characters from a field using MS Excel, containing similar to the following data: Miss M A Budgett W/T *094169/2 In the next field to the right, I want everying after the * to appear: =TRIM(REPLACE(D15,1,FIND("*",D15)," "))...

Hi All I have three sources of data which all equate to a reconciliation of the same data e.g. the same record of a stock holding is held on three separate systems, which must all be the same. I am trying to build a an equation in a query field, which compares each quantity: Qty Diff...

Hi All I am trying to set up a calculation between two values to show the percentage difference. In Excel, for example, I would have two values, £905,175 and £891,563, and I would enter =A1-G2)/ABS(A1), which would then return a plus or minus percentage value. Any ideas how to do this in a...

Hi All I have been working on a stock & share reconciliation process, which was originally carried out manually, by looking at three separate reports and ticking them against each other to spot any differences in quantity of shares and their values. I have imported the three Excel files into...

Hi All I am currently in the process of automating a stock & share reconciliation process, where there are three different sources of data. Two are emailed in to me, and which I have written macro's to import. The third source comes from a spreadsheet, which I want to be able to write a...

I have an invoice system, where the payment due date is the last working day of the month following the invoice. For example, if I produce an invoice on 5th June, the payment will be due on the last day of July. Any ideas what I can put in a text box to automatically calculate that date...

Hi All I have a database, in which I have three tables which hold 'static data', which will be used over and over again to record work and produce invoices. The Tables are as follows: tblManagedUnit MUID (Key) (One to Many with CircuitName below) MU Number tblCircuitName CircuitNameID...

First of all I would like to thank all of those who have guided me along the way. This is the best site I have ever had the privilege of being a member of. My learning curve is still on the upward! I would, once again, be grateful for some advice. I am at the planning stage of designing a...

Hi All I have a database for tracking jobs & producing invoices. The 'static data' is of course linked to each invoice. I need to create distinct transactions for each invoice, so that if the static data changes, such as rates of charge, it will not automatically update any history, where a...

Hi All I have a report, based on two tables which I have combined into a query. The first table is the invoice date & ref, and the second table is the invoice amounts & descriptions, which could be more than one. I have based the report on the underlying query, and I want all the many...

Hi I have developed a new database using Access 2003, which I need to roll out across various users. Some have XP, some Windows 7, and each of them has different size screens. I guess I will have to adjust the various forms to size to a particular users screen resolutions and sizes. Is...

Hi All I have a Form with an unbound combo box which, when selecting a date in the drop down, the underlying continuous subform populates with data. I have added a switchboard control which opens the form (in edit) and, even though I have managed to get the main control to be clear on entry...

Hi All I have created a simple database, with 2 x tables. The first is a 'Week Ending' table, with a dateid key and Week Ending field. I have created several week-ending dates in order for a user to input details of work done the previous week. The second table contains the details of the...

Hi All I Seem to be stuck on a small problem (aint it always the case). I have a report, based on a query, where the field name is "Date of Work". The criteria in this query field is >=[Start Date] And <=[End Date], which works fine. However I need to have the start and end dates to show in...