Search results

Hi Folks! I've been asked to make a 5 questions test to evaluation potential new employees' knowledge of MS-Access. Honestly, I need your input on what to ask. The goal is not to make a very hard test, but rather to see if somebody as at least basic knowledge of SQL and Ms-Access. Some...

Sometimes, the solution is so simple! Here is the solution that I found, based on your help: xlsSheet.Range(xlsSheet.Cells(1, 1), xlsSheet.Cells(1, 1)).AddComment.Text strTMP xlsSheet.Range(xlsSheet.Cells(1, 1), xlsSheet.Cells(1, 1)).Comment.Shape.ScaleWidth 1.75, False This code enlarge the...

I'll try that, thanks! I'm quite willing to work hard to figure this one out.

Hi everyone! I'm using Access to generate an Excel file. I'm exporting my query in Excel format. Then I open it in Access and do a bunch of cosmetic changes (such as making lines, bold titles, etc). I'm also creating comments inside the Excel file based on information stored in a table. The...

Yes, I do back-ups. That's not the point.

Here's more information: 1. I'm using Access 2000. 2. I've searched the web and this forum, hoping to find a solution. It seems that when the database is closed, it's too late to recover the data. If there is a magic solution, don't hesitate to share it (heck, I'm an optimist).

I lost a table in my MS-Access. Is there anyway to undelete the table once the database was closed? I appreciate any help you may have.

I have a table that goes like this (this table tells us what minimum we can order from a supplier): SUPPLIER PRODUCT ORDER_QTY ORDER_UNITS SUPP1 CHEESE1 200 $ SUPP1 CHEESE2 200 $ SUPP1 CHEESE3 200 POUNDS SUPP2 CHEESEA 200 $ SUPP2 CHEESEB 250 CUBES...

What I do is this: - Open the xls file in VBA code. - Format the column holding the numeric value to "# ### ##0.0#'. - Save & Close the xls file. This doesn't actually truncate the value. But it does appear to be truncated for those looking at it.

Comment the lines "ON ERROR GOTO". When you have an error, Access will pop a message. You could also modify the code following the label when the "ON ERROR" points to with a "msgbox err.description".

Well, having suffered from what Access calls a "Query too Complex" problem, I would that yes, it can be too big. How much? I dunno.

I'm sorry if I've skipped a few explication here and there. It's always easier when you're talking about something you understand. Let's table an example with my table BRANCH. Division and Warehouse are my unique key (put together). Here's a sample: TABLE BRANCH DIV (Division) WHSE (Warehouse)...

They are coming from a recordset. I have a table detailing my 30 Divisions & Warehouses. I want to loop my recordset, and output in excel format the same query, but with different parameters.

Yes, you can use VBA to append data, instead of importing into a dummy table and than appending. What you need to do, is create an Excel-object and open your xls file with it. This will enable you to see the value of the fields you want, launch a couple a append statement. If you have big excel...

I suggest you do this: ListBox.RowSource = strLinkCriteria 'change your SQL ListBox.Requery 'this updates the list box Note: Your code would needs to take into account the fact that you may need to remove or add the criteria. This code would only add and add and add. Do something like this...

I would be really bad programming to have a timer execute a dummy query every minute or so (enough to escape the time out). This time out period is something that can be altered. Perhaps the DBA or who ever is in charge of this DB can extend the time out period. Otherwise, you could always...

Thanks for your suggestion, but I'm not using it with any textbox. What I am doing, is running a recordset with my 30 divisions and warehouses. I want to output the same query, but only with the data relating to them (and thus, the parameters). Currently, I have a dummy table to which I update...

Probably. Just unsure how. I'm more familiar with Oracle or Access. Sorry.

Are you sure they use a MS-Access database (you just never know!)? I googled "restore .bak file" and got a lot of SQL Server related results.

Have you tried renaming the extension to .mdb or .mde and see what happens? If it's not working, you should ask them directly.