Search results

Hi all, I hope someone can help me!! I want to import data on a monthly basis into tables, but I want to be able to use the same import buttons each month and pass the data into the relevant monthly table. My Steps - Set Reporting Month variable (which sets the Table name Variable), choose...

Thanks Rabbie, that's brilliant. Now all I have to do is implement it. I'm half way there, and this will put the finishing touch. rgs Ginny

Thanks David, that has given me a couple of ideas that I will try. I think I may be able to make a composite of the Day and Month and add it to the year variable to build the date at the start of each month. I will have to do the same for the end of the month also, and I think I may have a...

I don't know if this possible, but would love some help on this. I am building a Trend of data on a month by month basis for the year. I have built queries which gives me the data I want in the format I want, but I have a problem. I now want to use the same Trend for every year without...

Hi all, I am using the following code to send out automatic emails containing some text in the body of the email plus an attachment and this works perfectly: TempFilePath = Environ$("temp") & "\" TempFileName = "Selection of " & wb.Name & " " & Format(Now, "dd-mmm-yy h-mm-ss")...

Thanks RG Looks great, will give it a go. Ginny

Hi all, Is there any way that Compacting and Repairing the Database can be automated? I tried to add this to a macro attached to an Exit button, but MS Access 2002 says it can't be done. I don't want the users to have to do this maintenance, but I won't be available to do it. rgs Ginny

You are right Adam, I had begun coding before building the macro, but hadn't deleted it !! All fixed. Thanks - there had to be a logical explanation. rgs Ginny

Hi all, I have a macro built that outputs the results of a query directly to a new Excel Workbook. I then put a button on a form which when clicked runs the macro. My problem is that after the macro runs Access appears to lose my database (grey screen) and freezes. The only thing I can do is...

Hi all, This is the first time that I tried to set up users and permissions on my database. I ran the wizard but found it quite confusing. I thought I had set up 3 users and still had the admin account. I didn't set up any passwords. Whatever I have done, I now can't access any forms...

Tabs can only be set for each form, as far as I can tell. I set the controls on the main form as 0, 1, 2, but when I try to number the tabs on the subforms starting with 3, they automatically hop back to 0, 1 ... Ginny

Hi all, I have a main form with 4 Subforms (same level). I have some controls on the main form. When I move from Subform to Subform the focus moves to the first control on the Subform. So far so good, but the view of the form moves down so that I can no longer see the controls of my main...

Hi all, thank you for your responses. I can't use a Union query as I need the results in separate columns. Also while the data is similar they are not joined fields within the query. My queries are separate to show - Dept 1 - total and percentage gain, Dept 2 - total and percentage gain, Dept...

Hi all, Would appreciate help on this. I have a query which combines the results of 3 queries. Once the underlying queries each has a result I get a result in my query, but if 1 of the underlying queries has no result I get nothing. (I hope this makes sense). How can I set my query to show...

Thanks, I'll have a read of those 2 articles. Hopefully I can manage it. rgs Ginny

Hi all, I'm not very experienced with Access. I'm looking for a very simple sample of how to export Query results to an Excel Template document. Especially to specific cell references. Would anyone have one to share. I'm trying to get my head around the concept first. I may have to use...

You have a lot more expertise than me! Good work. I'm not great on Access. Excel ok, VB ok, just not Access!! Ginny

It works as an expression directly in the query. I didn't have to build the function. That's great - THANKS RG.

Looks good RG. I'll see if I can manage it. tks. Ginny

That's ok, you just untick the 'show' for all fields except the Field with the Expression. Ginny