Search results

I have a linked table that comes from SQL Server. This table has a PK defined, Identity is True and Identity Increment is 1 It checks to see if a record exists, if it doesnt it suppose to insert a new record into my table. The 4 columns in my table in SQL Server are CTCC_RefIID (Primary Key...

I have a table in SQL Server that a column uses a FLOAT Data type. If I create a table link in access from that particular table, the column where the data type is a float some values looks odd. e.g. In my SQL table where a rate is defined it looks like this: 0.00300000002607703 But when I...

I am currently working on an application where I am using MS access as my FE and working with linked tables to SQL server BE. I also have a few temp tables within Access that are not linked but needed. 1. What are my steps into making this into a SPLIT DB? I am assume the BE will have my...

I know that this question has been asked many times, but I can't seem to find the proper solution. My subform is filtered via using VBA. e.g. strFilter = "[FK_D_TO_ID] = " & passProgram & " AND [isPending] = " & Me.txtIsPending & " AND [isApproved] = " & Me.txtIsApproved...

I have a combo box which I define a SQL statement as its rowsource. When I open the form, I have yet to define the SQL statement for the combo box. My code is: if me.cmbobox.listcount = 0 then me.cmbobox.enabled = false else me.cmbobox.enabled = true end if But it shows the box as still...

I am looping through a TABLE1 and in that recordset, I am inserting those values in another table called TABLE2. But it seems when I attempt to add the new record in TABLE2, it seems to hang and I cant figure it out. I have narrowed it down that if I COMMENT out the .update, my code will loop...

I have a listbox which contains a list of schools. I would like the user to be able to select 1 or all the records from that list box. From that list of selected records, my goal is to allow the user to use each school selected and use that as a record source for a continous form so I can...

In my QBE, I have a field call [startDate] In my criteria, I am passing a parameter from a form. Currently, I am using: DateValue([forms]![myForm]![txtStartDate]) From myFORM, the value of the text box is 3/1/2013 When I run the query, it runs as expected and returns all records with the...

For some reason, this error appears: Run-time error '94' Invalid use of Null This has all of the sudden appeared and nothing has changed. Here is the following code below. Private Sub SummarizeIntrastateFilersElectionStatus() Dim db As DAO.Database Set db = CurrentDb 'Dim...

When I run an Append Query, it only takes 2 seconds to complete for testing. It appends 25 records to a link SQL Server table. But If I create the same type of Query in VBA using Dim str2 As String str2 = "INSERT INTO dbo_CompanyToTypeOfElectionStatus ( FK_KCN_RefID...

I have a CompanyList table that exist on my local database and on a remote SQL Server database This table has the following columns: CompListRefID,CompanyName , State I created a query which compares what records that have been added in the local vs the remote table. What I want to do is any...

Prior to splitting the database, my PassThrough query performance was acceptable. After splitting the database, my passthrough query has become sluggish and slow where my users are not very happy. When I run a test prior to splitting my database, it would take about 1-5 seconds to retrieve...

I have created an .accdb file in Access 2010 and split the databases. I then created a .accde file in Access 2010. Now I found out that a couple of my users who want to use my .accde file has Access 2007 on their computer. They cannot open my .accde file. How do I create a file so my Access...

I have inherited a .MDB file. All of my users are on Access 2010. Can someone point me a reference area where I can prevent the USERS from manipulating the tables, queries, forms and macros and modules directly. All I want them to do is access forms and do the data entry from there. Thanks.

Here is a code that I wrote and I was wondering if anyone can shed some advice if there is a better way of doing this. I am open for suggestions. Please provide helpful advice. Thanks. The code works but I am wondering if I can make it better. Private Sub cmdSaveRecord_Click()...

MODS: If this isnt the appropriate area, please move to the appropriate forum. I have researched this topic in this forum and still have not found a viable answer. Maybe this will help someone answer my question by actually give the steps on how to duplicate this problem. I am running...

I was wondering if its possible to test my ODBC connection using my DSNLess connection to my remote database without creating a query or table link? Is there a sample VBA code I can look at? Thanks.

I have 3 queries in Access 2007 tableA - same structure in local and remote database 1. Query1 (Query based on a table "A" in the LOCAL database) 2. Query2 (Query based on a table "A" on a REMOTE database using a pass through query set up) 3. Query3 (Query based on what records are different...

I have a textbox which I allow the User to enter text. Kinda of like an area where it keeps a log activity. By pressing CTL + ENTER, it will give a LINE BREAK in the text box, which is great. But if I want to pass the multiline text to an e-mail and/or insert it into a database, how do I...

I am trying to convert this query I have in TSQL. I am running into problems on the proper syntax. This is the original syntax. SELECT u.UserID, u.FirstName, u.LastName, u.Username, u.Email, u.DisplayName, up1.PropertyValue AS TypeOfAccess FROM...