Search results for query: *

Hi, I need to create a contraint to check for CHr(10) and chr(13) at the beginning and end of a text field. I was given this code to use, but I get the error message "'chr' is not a recognized function name". Using the following example: The Table name is CustomerName The Field Name is...

Works great. Thanks!

For starters, we have this code in SQL. We are trying to convert this to Access VBA. The purpose of the funciton is to scramble names to make this unreadble. The function will convert a name by taking each character and moving it up one in the alphabet. For example A would becomie B in the...

We have a SQL table where we want to set the default value for some of the fields = 0. This is too avoid having a null value in the field when there is no value for these fields. These fields are set to the data type "money". When we append records to the table(using MS Access as a front...

We are all set up using Windows authentication, including myself. The users with the read/write priveleges are set up through a Windows group. I am set up as an individual user in SQL.

Hi, I am currenlty set up as a Db_owner on a SQL Server 2000 DB. I have a windows user group set up datareader and datawriter as well, where they do not have permission to delete data from a 4 or 5 tables in the db. They have full permission on the remainder of the tables. For some reason, I...

Is it possible to set up a table in MS Access and making it read only without going through a form?

I am in the process of setting up a SQL database, and need to set up different users. Is it possible to set up a user who would have limited Admin ability, such as the ability to change table set up (new fields, delete fields, etc.)but not be able to actually make changes to the data. This...

I am in the process of setting up a SQL Server Database with a MS Access Front End. The problem that I am having is that when someone else is logs into the database, myself or someone else gets a Connection Fail Error and needs to re-link the tables using the DSN I set up. Once I do that, the...

I am in the process of setting up a SQL Server Database with a Access Front End. I have 4 people who are going to share this database. I set up the security so that each person has his/her own log inand Password. We did this to because we have Audit trail triggers set up to track any changes...

Thanks as well. I usual break out my code into separate pieces if I am having an issue with. That way, I can find what the problem or issue is.

Thanks. This is what I came up with, and it seems to work okay. ALTER TRIGGER Customer_Name_Update ON Table1 for update as if update(Customer_Name) UPDATE TABLE2 SET TABLE2.CUSTOMER_NAME = INSERTED.customer_name FROM INSERTED WHERE TABLE2.CUSTOMER_CODE = INSERTED.CUSTOMER_CODE...

I am putting together a trigger to update 2 fields in a second table when a field is changed in the first table. The Trigger should work like this. The user updates a customer name in Table 1, and the customer name is updated to reflect the changes in Table2. In addition, the trigger should...

Thanks. The database we are using is a Back End Database, and the Front End(in Access) is already set up with these field names with spaces in the name. All our queries are set up using these Field Names, so we are debating whether or not we should start changing stuff.

Hi, I am in the process of starting to switch over an Access Database to SQL Server. The Access DB was not origanlly set up by me, and there are Field names with spaces in the actual Field name(Example: Customer Name as opposed to having Customer_Name or CustomerName). I tried importing the...

Hi, I am trying to run the Switchboard Manager in Access, but keep getting "Invalid Call or Argument" when I try to open it up. The only way to change the Switchboard is to go into the Switchboard table. Is there anyway to fix this?

I have an Option Group on a form with letters of the alphabet. When you click a letter, and list appears in a box to the right. I want to add the numbers 1-9 to the list of letters as well. Here is the code: Set R = CurrentDb.OpenRecordset(SQLText) For Button = 1 To 26 With...

Thanks! I ended up adding another line to the spreadsheet to add additional text. I also added off to the side an If Statement which flags anything over 255 characters, and built something into my code that stops the user from going ahead with the copying until the # of characters is <= 255...

I am working this macro that copies several sheets into another workbook. One of the cells has text that keeps getting cut off. I checked the # of characters in the original cell, and it totalled around 472 characters total. Here is part of the code: vMacroBook = ActiveWorkbook.Name...

I have a request to set up in a database I created to have the ability to email several reports at once. The Docmd.sendobject only allows, as far as I can tell, one report at a time, leaving me to set up individual emails for each report(There will be 6 reports at the most going out in one...