Search results

I'm sure hoping this is possible. I have a report with two subreports. It works perfectly. It does just what you'd expect a report to do... print data from my database! Now, the same report could be used as a HARD COPY form for my coworkers to fill out long-hand. Then, they could turn the...

I'm looking to do exactly what you all are talking about... export directly to a CSV file. Would you please post some of your results for reference?

:confused: I've searched and searched... I can't seem to find anything close to this. I have 10 sets of fields: [Photo01date], [Photo01], [Photo01note] [Photo02date], [Photo02], [Photo02note] [Photo03date], [Photo03], [Photo03note] etc... These 10 fields are shown in my form for entry. There...

Ok, I think I see what you're trying to do... your code will force my cursor onto a specific control when a new image is loaded. Preferably, I would like my cursor to simply not move at all when a new image is loaded. Otherwise, I'd like it to snap to the "Next Record" button in the navigation...

I've created a form. Within that form I have an image control. I am using this code to pull the corresponding plant image from a folder filled with JPGs. It works just fine except one thing. When I change from record to record my cursor jumps to the center of the pulled JPG. I don't want my...

MOST EXCELLENT!!! Thank you. It worked like a charm. In case anyone wants the backup code without the WinZip function, here is my stab at it. Dim fso As FileSystemObject Dim sSourcePath As String Dim sBackupPath As String Dim sSourceFile As String Dim sBackupFile As String sSourcePath =...

Considering I don't know what that's talking about... How do I set a reference to the Microsoft Scripting Runtime??? :)

I'm trying to make the code posted work for my database. I do not want to zip the database (unless someone knows how to use the native Windows zipping tool as I do not have nor do I want WinZip). I can't seem to get this code to work. Everytime I run it I get a message saying: "Compile...

I think I may have figured this out... I just use subreports. However, something seems to be wrong as I will have to create about a dozen subreports (I only mentioned Field Manager and Sales Consultant but there are plenty more). Is that ok that I have so many subreports? Or am I approaching...

Ok, I can buy that. But, I want to report the employees numbers in my Neighborhood report. How then would I do this?

Alright people... I'm ashamed to even ask but here goes. I have two tables: 1) Employees 2) Neighborhoods Table Employees has a comprehensive list of all employees and their information (including phone numbers). Table Neighborhoods has lots of information about each neighborhood we're...

Excellent. Thanks for your help. In addition, I thought I'd post that I am using the "call" function to apply the same code for different functions (BeforeUpdate, OnClose). This way I don't have to retype the same code!!

I can't imagine this is hard... I just can't seem to figure it out. How to I force code to run JUST BEFORE I change from one record to another record in a form. I also want it to run if I close the form. Basically, I want this code to run whenever a LEAVE A RECORD in a form. Can anyone help...

:D Woohoo!!! I was just about to post a follow up question... but I solved it. Now I thought I'd spread the good word to the rest of you! I was trying to use this same code for my form. Only, in my case I want this code to be applied in the After Update event because I want the filter to be...

How do you make the criteria be the combo box? In my form, the item is named "Category" In my Governing table, the item is [Category] In my dependent table, the item is [ItemCategory]

Has there ever been a resolution to this problem? I am running Access 2000 and I have the same problem. Any help would be appreciated.

I understand your confusion... in most circumstances, I agree. However, for this purpose my details section is different than normal. The details section is very large, designed to span one whole page for each and every entry. The report contains a myriad of information including pictures...

Might you have a reference I could check out in regard to the code? ...Really, now that I think about it... Could I just specify 'From Left' and 'From Top' with: Me.OBJECT.Left = 5.71 Me.OBJECT.Top = 3.45 Damnit! If only I had access to my database. I will have to check this out tonight...

hehe... Right, I could do that. That doesn't really solve the problem though. I'd like the Top Text Box to manipulate itself correctly and the Bottom Text Box to be set on the page. Is there no way to keep to an element in one place while having others change?

If the Top Text Box is too big: the Bottom Text Box Gets shoved to another page. I don't have access to my database right now but if I remember correctly, I was able to get around this problem by preventing the details section from spanning two pages. If the Top Text Box is too small (ie, it...