Search results

Hello, I’m looking for some advice on designing my database for an app I’m creating. Every time I do a design it looks wrong and I keep thinking there is a better way to go about it. I can’t tell you what the actual app is going to do but it’s similar to a user being able to post a job and...

Hey guys, Anyone good with Access charts know if it's possible to change the value axis values. I create a chart getting values from a query I run, it plots the values but auto selects the value range and the increment. The values on the value axis are: 0, 0.25, 0.5, 0.75, 1 Is there...

Hello, Is there any way to reference a worksheet number in a cell formula in a different worksheet without having to know the worksheet name. Eg. I currently have: =Global!B1 This gets the value from the cell B1 in the global worksheet, but I want to be able to doing something like =...

Hello, Basically I want to save a worksheet from one workbook into a different workbook within access. How do i go about doing that? I was guessing I could open two excel application objects and open the workbooks or worksheets there but i wouldn't know how to save one onto the other. The...

What is the best way to find duplicate records in a table with 25 columns!? I know there is a built in find duplicate query but it only allows a max of 10 columns to be compared. Edit: I actually want to find duplicates records between two tables both the same layout and columns Any help...

Hello, need some help on the best way to go about validating a text field. Basically I have a main table which contains records imported from an excel file. Ideally the field should be a numeric data type but because a user could enter text in excel by accident, I would get an error when...

Hello, this should be easy but every thing I tried isn't working or only partly working. Basically I got two tables, 1 main table with all my information and 1 with just values which are allowed in a column in the main table. In a query I want to remove records where in the particular column...

[Solved]Saving Excel file from within access Hello, I've spent hours trying to solve my problem and tried so many solutions and none have worked. Basically from within access I'm opening an excel file, editing it, then closing and saving it. It works until I get to closing and saving it...