Search results for query: *

Hi, I'm trying to call a procedure stored in a form from another form. I have made both procedures public subs but get an error message when executing this code: Call cmdExportToExcel_Click Is someone able to help? Thanks, Bhavesh Power is Knowledge Knowledge is Power

Hi, I'd like to know whether it is possible to create a Chart (placed in a form) based on the results of a form as the form is based on query and uses filters (stLinkCriteria). If this is possible - how can I get started? Thank you. Power is Knowledge Knowledge is Power

PHV, that didn't work - it doesn't refresh the subform if it is empty to begin with. Only works if there is something in the subform already. Do you have anymore advice? Power is Knowledge Knowledge is Power

Hi, I have a subform which I want to refresh/requery so it shows the most up-to-date value after I have made a change to a table it picks data from. Currently I have the following line of code, which only works if there is already something in the subform (i.e. not blank)...

Hi, I have a list of dates to which I want assign quarters ie. Current Quarter, Quarter-1, Quarter-2, Quarter+1, Quarter+2 etc. For example, on the left we have the dates and on the right we have the quarter it refers to. 01/01/2006 Current Quarter 31/12/2005 Quarter -1 15/06/2006...

Exactly - this is what happened to me. The code query was much faster. Not sure this can be universally applied - but I suggest you experiment. Power is Knowledge Knowledge is Power

Just tried it - works much better than when I manually created a query using design view. Only took a few seconds to append 53k records with lots of indexes. I recommend anyone who has tried to use an append query in design view to try this instead. Excellent. Power is Knowledge Knowledge...

Hi, I've searched the threads and have not found an answer to this. I'm trying to copy the contents of one table to paste onto another - without using the append funtionality - too slow and doesn't work in this siuation. So far I've got... Dim ds As DAO.Database Dim rs As DAO.Recordset Dim...

use the column width functionality in the properties section of the form design and set it to something like 2;0 where 0 is the colum you want to hide. Power is Knowledge Knowledge is Power

Thanks for the suggestion. What I've done is created a macro to delete the current contents of my tables, import the tables from the mde, append onto the existing tables and then delete the two temp tables. A bit long winded but easiest way I found to do it without breaking relationships...

Hi, this the same problem I have. But do not know what Dawn referred to by 'follow the wizard'. Can't seem to find a wizard for import macros. Power is Knowledge Knowledge is Power

Hi, I've tried to look through many threads - but have not been able to find the solution. I have a 'back end' mdb file which I use to develop new queries/form etc in other words to do my work, every couple of weeks or so I create a mde file to and store it onto a network drive to share with...

Got it. The solution: Try creating the listbox on the select query without the the parameters then readd them after the listbox is in place. Power is Knowledge Knowledge is Power

Hi Kyle, I'm having a similar problem as described above but my criteria for the query is coming from a form. I tried your suggestion above but it did not solve the problem. Here's my query: SELECT [Global Business Warehouse data].[Country key], [Global Business Warehouse data].[Employee]...

Good point. I meant to write I have 49 fields and 47,000 records! I have to create this 'bloat' as indexing makes such a big difference. Your reponse helps. Power is Knowledge Knowledge is Power

I have created a Main Table with 49 records and about 15 indexes. The problem is that the contents of the table gets deleted monthly and replaced by new data (cut & paste). My question is: By deleting and then pasting data into this table am I adversely affecting the indexing, and will my...

No I can't format the smaller tables beforehand. Unfortunately your suggestion does not help, as it I already knew what I wanted to do but did not know how to do it. Power is Knowledge Knowledge is Power

I have a 'Main Table' which gets updated every month with three other smaller tables (smaller in terms of records). My problem is that the smaller tables may not necessarily have all the fields of the 'Main Table' or may not be in the same format (ie. datatype, field size, indexed) and/or in...

you asked for it: SQL: SELECT qrySuccession_Positions.Function, qrySuccession_Positions.[Country key], qrySuccession_Positions.Region, qrySuccession_Positions.[SAP System ID], qrySuccession_Positions.Employee, qrySuccession_Positions.[Last Name], qrySuccession_Positions.[Name prefix]...

Yes I have - and it asks me to enter the value of the calculated field. maybe you could give me an example? Power is Knowledge Knowledge is Power