Search results

Hi all, after a long absence. How do I run Access functions, like Format, in Action Query using CurrentDB.Execute?? I'm trying to write the following query with Format function in a Select statement, but I'm coming across few issues. 1st, I'm getting Syntax Error. 2nd, even if i design this...

Maybe i posted this in a wrong thread earlier. Adding another screenshot for reference: I've got a query that when i run without enabling Unique Values, returns over 750,000 results and with Unique Values enabled... about 15,000 result sets.Query contains 8 tables. I've a selection form...

Thank you so much CJ, it is done. I knew we could do something like this, but you gave me a clear thought. Cheers!

I've a very large table to import from an Excel sheet, over 2500 rows. There is a combination of 5 repetitive fields which I want to break in a separate table. This will be the parent table. I don't want to import everything in a single table with lot of repetitive fields. Now if i break this...

I've learned quite a bit of VBA till now, but I've very limited knowledge about dealing with dates. I've a table full of quantities installed in a field on daily basis. In other more familiar words, it is like record of sale for a specific product in a shop on daily basis. Let's say, standard...

Thank you guys, got it working. There was an issue with PK/FK relationship. Figured it out by picking up the hints from your replies. Bless you all!

When I import from Excel to Access in a single database using VBA below, it works fine. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "tblBoQ", "c:\Import\BoQ.xlsx", True ... but then when I break the database FE/BE, I get the attached error. Data type, field size, etc...

Thank you, Gemma. Your advice is valuable. I do learn from the books but learning from books seem to take a lot more time than video’s, OR, is it just my assumption? So far I’ve gone through couple of Access books, an intermediate level database design book with a nice set of initial knowledge I...

I've split the tables again and now it has appeared, along with Relationship lines. Maybe it was not appearing first because I tried to split tables in multiple backends, maybe??

Thank you Coach. I'll take your advice and learn about it as time allows. At the moment, I'm more interested in relationship diagram only as this is the immediate problem. Yes, it does but there it shows tables only without lines showing the 1-1 or 1-Many relationship lines. This is what i...

Thank you Spike, I've taken your advice and definitely act on these workflows as soon as I get some relaxation from current works. I am more interested in DB side of a career at this stage. Regarding workflows, the guy who requested me to develop says that it's a new system which will overcome...

Guys, The database I'm currently working is a big project, but I've a requirement to implement database as I complete each module... starting from tomorrow. I primarily planned to implement the backend/frontend scenario, but when I will do that I will not see the relationship links in a...

I've requested my company to book me for couple of advance courses on databases. I want to do an advanced design course because i consider myself weak in DB Design, plus advance SQL language course, or maybe T-SQL, because I'm more towards Access and SQL Server. As professionals, will you guys...

Spike, I've requested for workflows. I'll post them by tomorrow if I get them. Thank you. That's the catch, company wanted to hire the database guy but I stepped forward and requested a chance. I am an enthusiast, so I think with a little help I'll be able to overcome. Believe me here in this...

Thanks spike, you're right that stuff in 1.jpg is more like stuff to be in junction table but the way things are calculated in budget or base values are too complicated and spread over several tables!! It took my huge time to understand the process below, so I don't know how to explain it well...

I've another design idea coming in and that is, instead of making a Junction Table Activity_Equipment, I create Equipment table a sub-table of Activity Tables since every Activity is going to be done on some equipment. And then make each ActivityType a new table and each ActivityType table will...

Well this is something difficult for me to explain without writing a very long article, but in short, we're an electrical services company in an oil industry. This part is the core part performing all the calculations. I'll not try to explain formula's behind calculations because they're pretty...

I've a design issue, yet again. I've two tables with many-to-many relationship, where number of activities could be done on an equipment, and similarly equipment might also be treated under certain activities. Junction table between those tables comes up with different set of requirements for...

Thank you Arnel, got it worked.

How I would be able to give user the option to select the path, like a File Selection dialog box, to save the exported file in below command? At the moment I'm just able to export in a set path, like "d:\test" in below code. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "tblBoQ"...