Search results

Hey all, So I got it to work! I used the object browser in the Access VBE to find the property that I wanted and then located the corresponding constant. xlXYScatterLines was 74 xlLegendPositionBottom was -4107 Plugged those in instead of the property name and it worked like a charm.

Hi all, I'm trying to format an Excel chart from an Access module. My goal is to have a temporary Excel workbook that appears to show data, and I don't want to have another Excel file as a template if at all possible. As of now I can successfully add all of the required data to the excel...

First off, thanks for all of your replies. Second, I knew coming in that this would be opening a can of worms, and I was fully expecting the first couple of responses to be "Why the hell would you do that?". I was hoping (foolishly) that someone had been able to do this using a crosstab query...

Hi all, I'm working on a project where I'm supposed to take an excel spreadsheet and replace it's function with Access. So far I have created the form, table, and query, now I just need the report which (according to my boss) needs to mimic the existing spreadsheet. I know this is probably...

Hi all, First off thanks for all of your support! I think I have a solution that will work. Since all five units are measured in the same day, I set up the table where each record has the date, unit#, and all eight measurement locations. Then, to keep the measurements grouped together I use...

@JHB Thanks for your feedback. In the current design Excel is definitely the best suited for the job. I'm hoping there's some way to change/modify the design of the data to make it work with Access. Because I know retrofitting the spreadsheet definitely won't be pretty or fun. The reason for...

Attached is the form that populates the table as it's currently designed. No calculated values are stored in it, I was going to evaluate those in a query later down the road. Where I'm stuck is that they take measurements 5 units at a time and then require a report to show those five units...

Hi all, I've been given a task to take an existing Excel spreadsheet and transfer it to Access. I'm a novice in Access, and I'm having trouble designing a way to lay out the data in tables that would make sense. I know there will be plenty of headaches down the road if I don't have a good...

Tried searching before and came up emptyhanded, will give it another go. Thanks!

The only other Criteria is for a date field. It's criteria is Not Null And Between two dates, where the two dates are referenced from the same form

Hi all, Hopefully someone will be able to help me with this. I've been struggling with it for a bit. I have a form which users can toggle whether they want to only see entries that has data in a certain field. Previously I have set up a separate query with a hardcoded 'Is Not Null' in the...