Search results

Finally worked out the solution. Whenever dealing with linked tables in Access and you change the underlying table definition when creating your front-end you MUST relink your linked tables for the changes to propagate to Access. In my case I had changed the linked tables data definition to from...

Thanks. Although I can see through SQL Query Analyzer that the table is correctly calculating and storing the value with a decimal, whenever I try to open up the database front-end in Access to view the form or even the table data I get the "Error scaling of decimal value resulted in data...

Can anyone help to get the decimal values in these tables to correctly show on the Access front-end? Thanks.

The linked table within SQL Server has a datatype of 'NUMERIC(5,2)', and when I go into Access then open the same table up in design view I can see that the datatype mentioned there is 'Number'. Of which the parameters under the 'General' tab are: Field Size is 'Decimal', Precision is '18'...

Thanks, but I'm not sure what you mean by changing the storage to text. If I do this through Access to try to amend the table storage definition well it won't allow me to save the changes as it's a linked table. But then if I try to change the datatype of the underlying table in SQL Server well...

Thanks, but I am doing all calculation in a trigger on the SQL Server end not Access. All I am using Access for is as a front-end to the data. The column definition of the linked table in SQL Server is NUMERIC(5,2). Access doesn't seem to want to display the data despite it being correct in the...

Hi there, I have a SQL Server linked table with a NUMERIC(5,2) datatype and a trigger on that table firing on an Insert or Update which all appears to be working as required as I can use SQL Query Analyzer to view the correct data being stored in the table. The problem is that on creating a...

Hi there, I have a form that contains 2 sub-forms, let's say Employee and Department. Is it possible for a sub-form to refresh or display the details relevant to the other sub-form? For example, if the user is moving through the records of employees one-by-one in the Employee sub-form is it...

Thank you.

Hi there, I have created a basic report in Microsoft Access 2003 using the wizard. Unfortunately this returns many records so I have the user asking if there is a way to have the report prompt the user for a parameter criteria that will restrict down the results to only the records of interest...

Thanks. Any chance of a dummies example on how to create the search button that would search on the customers name?

Hi there, Can anyone advise me on how I can create a command button in Access 2003 that searches for a specific record? I know you can create the default one through he wizard however that only searches on the priary key. The command button I'd like to code searches on a fields string. Thanks...

Okay thanks I am at home now but will try this at work on Monday. As stated it is okay to ignore this error as the stored procedure has been well tested I just don't want Access throwing it.

Yes it's displayed in a message box.

No, the error is unresolvable as it is thrown as a warning as part of a deduplication process hence the reason why I'm wanting it to be ignored.

Yes that is correct however other queries run fine on the database and don't require constant logging in.

Basically the error is thrown by the mail_proc_beta stored procedure below which is a package of stored procedures. Any subsequent procedures are then obivously not run because of the error. The error CAN be safely ignored I just need to know how. Private Sub Command49_Click() On Error...

Is it possible for me to bypass the error message #3604 'duplicate key was ignored'. When this error message is thrown it stops processing the subsequent stored procedures so just want it by-passed and not displayed to screen. TIA

It opens up the 'Select Data Source' box. I then have to rechoose the user DSN. After that the query returns the results successfully however if you select to run the query again you have to go through the whole process again.

One of my queries is repeatedly asking for a Data Source whenever you execute it despite the user already being logged into the database. Is there a way to disable this? TIA