Search results

Hi all, Is there any resource that gives a definitive run down on all the errors that can exist within access; their causes and solutions. For example; the enter parameter msg box that appears when it doesn't recognise field value. Just curious. Thanks

I have an interesting problem. There is an Excel file which contains data I need, but, due to the formatting of the data and the size and scale of the file I cannot simply import into access and integrate it into my existing database. So, what I have come up with is this; Firstly, from Access...

Good day. I have a report which shows all cables pulled and their date. I had them grouped by week, but, I have being asked to group them by the day that they have being pulled. So, I decided to mess around with the Format expression and came up with this. =Format$([Cable Pull...

This little book is full of useful tid-bits and I've found it very useful and informative. The book is "Access Hacks" by O'Reily written by Ken Bluttman. I would say that the book may not suit access beginners, it appears to be aimed more at novice and expert users who may not be aware of...

Hi, I wonder if anyone could solve this issue for me. I have a module that will export to an excel sheet and place values in specific rows which is fine, however as it stands the exact file path of the excel sheet must be present in the code. the problem with this is that the excel sheets name...

Is it possible to open a report using a combo box. At the moment all my reports are opened using cmd buttons. This is just a question of curiosity, I will continue to look into it myself of course.

This is a snippet of code that I used for a DB that I am currently upgrading. I used this module to update a table that had a couple of thousand records. The problem was there were a number of string values which had different integer values associated with them, for example, if the char 'p'...

I would like to extract a particular part of a string and do a calculation on it. Example would be as follows. Field = Code Value = LV-3P004sq So if there is a P in the value it will = 3 and this shall be multiplied by the preceeding number (in this case 3*P = 9) the result is then placed in...

Is there a way to set up a text/combo box so the user could enter a wild card search, for eg. at the moment there is a query where the field 'Route' has a criteria as follows Like "D???211", which is a pain. Now, there is a combo box which will get data from that field and from this a report...

I recently came across the GRANT statement in Access which can be used to give certain users assigned privilages, so my question is; is there an equivalent method which can be used in excel. This isn't a vital request, just curious. Thank you in advance.

Is there a way while using the count query to make it return zero when using the criteria (not like "N") instead of a blank datasheet.

This is a frustrating problem, I want to count all entries in a field that are "N" but instead of displaying the total count ie 120 i want it to show 0 until "N" is replaced by "Y". what I have got so far is SELECT [CABLE DATA QUERY].TOP, Count([CABLE DATA QUERY].[Cable Test]) AS [CountOfCable...

What I would like to do is export certain data from a report made in access to specific cols in an excel sheet (Within a certain range, eg A3:A78, A86:A119). Firstly is there a simple way to do this or will it require a certain amount of code.