Recent content by accessNator

Hello Gina, I dont have any BIT fields in the particular table in question but did run into that issue a couple of days ago. As you posted your reply, I figured out the problem on a post previous to this.

I figured it out. I did have some columns configured improperly in my SQL Server table. In my original post, I had FK_KCN_RefID and FK_TOC_RefID had actually assigned Foreign Key attributes and some type of constraint was preventing my code from inserting new records. I removed the Foreign...

How so? my CTCC_RefIID column is already set in SQL server as a Primary Key with Identity Seed and Increment as 1. Wouldnt any record inserted not need this defined in my code? It automatically populates the next highest number?

In my code, I can definitely Edit a record, but I cant Add one. When I put a break in the code and step through it, when it gets to the .update syntax, the process hangs a bit then I see the error message as stated. I can also manually ADD or EDIT a record via SSMS interface.

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...

Thanks for the term. I will look it up.

I thought about that too, but I needed the TEMP tables within Access. I know its better practice from what I read but I needed those temp tables so my continuous forms have a local place temporarily. Maybe I'll revisit the code to make it more efficient. I know it may create bloat, but I have...

In my Access App, I already have the sql tables linked via ODBC. So I really dont have to worry having a BE access DB correct? I can simply just create the ACCDE, correct? Thanks,

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...

Oh I see. I see what it does. Not what I was actually looking for on my solution. Thanks for your reply back.

Thanks for your reply, but I am not sure how to use this.

I was able to export my filtered results as given by your link. But is there a way to only export what I am actually displaying on the subform? The underlying subform, uses dlookup based on values of the queries fields and also in the query being used, I dont want some of those columns exported...

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...

Thanks for your reply. Its weird that when the row source is set to nothing, it still wants to think there is a record in place. I saw an interesting post after doing more searches with another workaround here in another forum who another poster posted the same problem...