Search results

first convert the field to varchar and use the left function to make sure you'll only capture 10 characters Something like this Then add the convert to datetime function convert(datetime,left(convert(varchar,yourdatetfield),10),103) Maybe that will work

Problem this type of message is generated in the database and is not seen as an error by both SQL server and Access, the same prob with foreign key messages. So you can't trap it unless you use triggers on the table which raise an error when an empty field is being forgotten. In my personal...

You could filter your view in access with the form properties but it would be better to use your view in the stored procedure and make a parameter in the SP.

Necessarily I need to use schema.ini to export a table (it's an ade database and doesn't work with the built in specifications). I'm trying to export varchar fields without " " quoted identifiers(i want it without ") but when looking in MSDN i can't find the syntax to tell access not to place...

Best practice is to distribute your report (to people with other printers) with the generic text driver chosen as printer. The users (or administrator) receiving the report is able to to choose the printer they have installed if they have the generic text driver installed.

Violations of SQL Server constraints or messages about 'nulls not allowed' are not being seen as errors by SQL Server. In this way I can't trap them in an error module to trap and redesign the message. Does anybody know how to trap them to make them user friendly?

One of my probs with access is changing the form when a different resolution is being set. Is there a visual basic module or something else to display the form properly dependent of the selected resolution?

I have a report which shows the products in a brochure like style including pics. When exporting to html the pics disappear. I would like to export it the following way: - report keeps same format, pics are being shown - an alphabet browser (a-z) above the report to easily jump to the desired...

For instance if you have employees make an employeeid footer and header. Place an imageframe in the footer and put a picture element inside it (for instance you refer to c:\temp\mypicture.bmp, the picture should exist). - Name this image picture element imageframe - Place an unbound text...

You can use the upgrade wizard in access. Look in the help-file

I'm using bookmark and it works well, until i delete a record. I requery the recordset in the after delete confirm event. Within my other event (before update, after update, after insert) i'm using bookmark, but they don't work properly anymore after the delete. Kinda odd because the requery...

I'm requerying a form after an update. I would like to have the form to be set to its current record when being requeried. How can I easily achieve this? I've seen things about recordsets, I'm working with ADP (based on SQL Server) and don't know or all DAO events will help me.

I have an adp (access project based on sql server) showing records with different pictures. The pictures are ole embedded and the records show the name 'picture', that's no proble. When right clicking the picture field I can copy it to word etc. and it will be displayed. How can I easily add VBA...

Thanks for the hints I'll be giving it a try!

Also in SQL Server 2005 reporting services?

is it easily possible to move your access reports to microsoft sql server 2005 reporting services?

i have a mdb and would like to upgrade to SQL Server. Instead of reprogramming it to ADP i thought an option would be using ODBC. is it possible to upgrade to SQL Server Express (put my tables in express) and use ODBC to connect with the database? Would this make sure I do not have to...

I've done alot with sql server adp and encountered the same problem. You can try the following: Goto tools>options>edit/find Goto show list of values in and select both options (records in local snapshot records at server) If you turn on the ServerFilterByForm property at your form, your form...

i'm using a Ms pivot graph on one of my forms which is linked to a broad query gathering alot of information about sales. It's a very nice ad-hoc query tool though some information might be misinterpreted if you put the wrong fields within a combination. Therefore I would like to store...

Access has a special event in a report called on no data. Simply goto the subreport and goto events Witnin no data set the following code Private Sub Report_NoData(Cancel As Integer) Me.Visible = False End Sub Set the can grow can shrink properties on the main report of the sub report to true...