Search results

I'm trying to figure out what I am doing wrong here. I'm trying to create the SQL MakeTable query on the fly and all the other sql statements are working fine. When I am trying to do the "INNER JOIN" that is where I am running into problems and getting the error message: 3061 Too Few...

I'm trying to see if is it possible to only "lock/unlock" parts of a specific field on a form. Example: I have a field called CCN with the value of 99-11-001-777-888. I have code that locks the field based on a users access level in the Security table. What I need to see is if it is possible...

Does anyone know how I can implement the following code into my existing "ProperCase" module so that it would work as one. The ProperCase code I got from these forums works great and has an "Exception List", but the only downfall is it can't detect numeric values before an Alpha character. Any...

I have a password set on the VB coding to prevent people from viewing the code. This has been working great until I try to use the code below: DoCmd.SetWarnings False DoCmd.DeleteObject acTable, "DateFlagged" DoCmd.OpenQuery "Clear License" DoCmd.Rename "Logon-D", acForm...

I have a password set on the VB coding to prevent people from viewing the code. This has been working great until I try to use the code below: DoCmd.SetWarnings False DoCmd.DeleteObject acTable, "DateFlagged" DoCmd.OpenQuery "Clear License" DoCmd.Rename "Logon-D", acForm...

I seem to be stumped and am hoping this is something easy to do. In the code below what I am trying to do is if the users clicks the "Yes" button; then the 'Case vbYes' (See red code) statement will continue processing the event procedure from the 'Else:' (see blue code) statement below it. My...

Here is my dilema; I have a handler for Error 3021, but my problem is that this can be the error for 3 different sections of code. What I need to accomplish is that if it fails w/ Error 3021 on the 1st part of the code to continue with the next part of code from the point in which the code...

Can someone tell me what I am missing or doing wrong here? I have been racking my brain trying to get this working. When I try to run the code I get "Run Time Error '3061': Too few parameters. Expected 1." Set rsTo = CurrentDb.OpenRecordset("Select [PERD Security Access].[Email Address]...

How do I send email from a table list? Can anyone please help me or lead me in the right direction as to how I can have this code be more effecient, by storing the e-mail address information in a table and having this code look to the table or a query to figure out which e-mail address(es) to...

Could anyone tell me what I am doing wrong here. I read through several posts and tried using the solutions, but to no avail. Here is the code I am using: Dim db As DAO.Database Dim MySQL As String Set db = CurrentDb() MySQL = "INSERT INTO...

I am in the process of converting my database backend from Access to SQL Server 2005. Everything was going pretty good until I hit a snag with this query. This worked fine until I moved the tables to SQL Server. To give you an idea of what this query is supposed to do. I have a search form...

Can someone please help me figure this out.. Can't for the life of me get this to do what I want. What I am trying to accomplish is that if a "Transaction Description" is Like "Gas*" Then allow that to be used without getting a "NotInList" error message, but if it is anything <> Gas* and isn't...

Could someone please help me get this figured out? Any help would be greatly appreciated. What I am trying to do is once the user clicks the "Save" button (thereby adding a new Bank Account to the system) I want to have a new record created in the "Bank Register" table automatically. What I...

Could someone please help me figure out what I am doing wrong here? When I open the database it keeps telling me "Run-time error '5'" Invalid Call or Procedure. I can't figure out what I have done wrong. In the "Tools/Startup" options I have the title set as "Financial Database" same as what...

I am in the process of converting my DB into SQL. What I can't understand is why since doing so is my custom error message putting a bunch of unwanted spaces in the message? (See attached image) Here is the code I am using. This was working fine until the tables were moved to a SQL backend...

Is there any way of trapping SQL Server error messages in Access and replace it with a more User Friendly easier to understand message? I have attached an example picture of what I am trying to trap.

I am trying to set the RecordSource of a List in the OnOpen even of the form based on the text box "Last Name" that is filled in by the user on the Main Menu. For some reason I can't get the code to work with the "LIKE" command what am I doing wrong? I am getting Data Mis-Match 13. How can...

I have a subform that I am trying to use for 2 differnent forms. "Provider Information - I" & "Provider Information - G". What I need to do though is have the subform check to see which form it is currently linked to / open. Then based on which form is open run If/Then statement code specific...

Ok.. I have been racking my brain for hours trying to figure out how to do this. Maybe someone here can help me figure this out. I have 2 tables. "AR94" & "RPIN" I need a query to look at the "Provider_PIN" field of both tables in order to find duplicates between that field in both separate...

How do I use IF statements within an Existing IF statement to accomplish different outcomes? I have been trying different code for a while now and can't seem to get it to do what I want it to. Here is what I want the code to do. 1st - if the field "Provider Number" conists of 6 or 8...