Search results

You need to use the image data type (there is no OLE Data type in SQL Server). Like with Jet the SQL table only holds a 4 byte pointer to the images which are stored in data pages. Regards Jon

We wrote all the modules in the MS VB Editor supplied with office exported them and used a freeware VB compiler. So I suppose you could say that it is VB rather than a VBA one; even though the application is purely Office programs and a third party MS Project viewer. We couldn't find a...

You must be a masochist :) I am no expert but I have always found the Access report writer to be almost as frustrating as the England football teams World Cup Performances. I agree with cable 100% that using precreated Excel Templates for loads of numbers or Word Templates for fancy looking...

Thanks a lot for your help, I never even thought about MDE files, amazing how I missed the obvious. But I still think the server for is the place for it My plan is Put the modules into Access and compile it as an MDE file with password. Put it on the server I will still be able to use the path...

Thanks, I suppose we could always put a copy of Access onto the Server.

Does any one know if it is possible to create DLL's with VBA? If so can anyone recommend a good site or book for instructions on this. I have an MS Office application that sits on our server it is properly registered within the windows registry and all works fine. The application consists of...

Good point Rich - I forgot about the format option in the Query property sheet

Bob's method will work fine but a point to note with putting calculated fields directly into a query is that care is required to limit the records being returned by the query if the underlying table has many records. I have found, through painful experience, that calculated fields in queries...

The best method is to use a form to enter data into the tables where the date is entered through a text Box named for example txtDate. This is bound to the date field in the underlying table fldDate. Create another text box on the form txtWeekday and bind this to fldDate or set the...

This is question isn't a specific problem but an index design query. I have developed an Admin database that produces project info, quotes on the project, itemises them assigns manpower and cost codes and links costcodes to a PO table this is relational through several one to many relationships...

I want to get an ADO recordset opened with a cmd.execute statement to have the none default adOpenStatic and AdLockOptimistic. even when specified prior to the execute cmd it opens with the defaults which cause the RecordCount property to always read -1 and worse the recordset is created as read...

Thanks folks It was an embarrassingly simple simple solution really but I couldn't see it Yesterday, Instead of adding an extra col into the SQL stmnt to calculate DatePart("ww"", [Field])and getting the parameter from the form I was trying to compare two date parts in the where clause. You...

Can anyone help I need to return records into a DAO recordset based on an SQL statement for the week of a year from a date stored in a table. I have had problems using the DatePart Function as an expression in the query. Thanks for your help Jon

You need to use recordset clone object of the form. Are you using ADO or DAO I have never really used DAO so I am unsure of the syntax. If you are using ADO in mdb file there is a slight problem which I have not managed to figure out, the recordset.clone method does not seem to work. There is...

Another point to add is when using ADO to execute SQL queries or statements As you mentioned if you are referencing a forms control as an SQL parameter you must use ! but if you are refering to the SQL parameter in ADO Access returns a collection reference error if either ! or . is used...

I think I have sussed it out Mile, most of the data comes from three seperate db's tables linked over our network. When I started the project (about 3months ago) I referenced the other dept db's to see if I could use any of the code. I must have forgotten to remove the references. The accounts...

Maybe try posting your db As a .zip file somone will be able to point you in the right direction. Sorry I couldn't help mate

If the Pk's are from seperate tables and the relationships are set a simple solution, though probably not the best, may be to right click on the joins in the relationship window and in the join properties select enforce referential integrity and make sure that allow cascading deletes is...

The relationships probably don't allow you to make cascading deletes Mile is the real expert I am just a hack, you could also try his code but takes longer to type

Set the warnings back on and see what it tells you