Search results

Yep RAK that is pretty conclusive alright. Thanks, its always frustrating when you get an error 3033 or whatever and you don't know what the hell it's about.

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

Basically it is a filter that the user will be generating and by doing so will be filtering the data of a number of columns in the excel file which in turn will be imported into another excel sheet which shall incorporate custom columns. The reason it is not being done in the excel file itself...

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...

Road Warrior where would recommend for obtaining a SQL server certification. I.E online what are the best sites.

Check the attribute of the cell in excel is it 'text' or 'number' and the same for the field of your table. That may be part of it. but may not be.

Try using SELECT DISTINCT [table].[Field] FROM [table]

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...

For Each obj In dbs.AllReports strlist = strlist & obj.Name & ";" Next obj Thanks John A. but the above code does fill the combo box with all reports in the db. Thanks for pointing out the syntax error on the path name of \temp.snp. Also, Code: SnapshotViewer1.SnapshotPath =...

There is a way in which you can use a combo box to select and also open any report. you can utilise the snapshotviewer which is a built in activeX control. (However you may not like using activex, so, I dunno; move on). Here is how to achieve it. you need this code in the form load event...

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...

Will do thanks

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...

shudda replyed sooner Thanks for the advice, I overcame the problem using a combination of DAO, InStr and Mid functions. You can see it in the code repository forum above if you wish.

thank you that was a useful piece of code, I went a different route but will use that code somewhere else down the line

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...