Recent content by AccessNut

Thanks, I'll check. Another thing is that the script was working before and then one day it stopped working. I'm trying to track down the server admin to see if anything changed on the server, because as far as I know there has been no change on the data input side (other than getting new...

I have a permanent table that I'm trying to insert records into from a temp table. The 2 tables are joined by AssetID. My query basically says for an AssetID in the temp table if it is null in permanent table then insert it into the permanent table. This is the error I get: Msg 8152, Level...

I did split it and tried it out. It was too slow for my users. We have about 20 people using it and if more than 3 are in it at the same time it almost grinds to a halt. Sadly new machines is not an option :-( It is only an issue if someone is not in the office but left their machine on and...

Hi, I have a recurrent issue with users parking in a network access database. I need to get them out of the database for doing things such as changing the design of a form. Sometimes they get into the database and forget to exit and if they are not in the office I cannot go just shut their...

Here's the set up: I am the dbo of a SQL Server 2008 database, and we have an Access front end. I have 2 users that both have db_datareader rights to the SQL server db. They have the exact rights in SQL server 2008. User A linked a table from the SQL db in the Access front end, which I can...

Thank goodness I still have a job but I'm thinking about "beefing up" my resume just in case. I have a BS in computer science but have not worked in that area for about 6 years. During this time I have been working in another field but hacking together an Access database at work and really...

I have and like this book: SQL Queries for Mere Mortals

I may have to upsize my Access database to SQL server 2005. I have no experience with SQL Server, have some experience with Crystal Reports, and I'm an intermediate user of Access. I have done a lot of programming with VB, C++, Java, but not the .Net framework. Basically I will need to upsize...

I have a split database, and I'm trying to figure out the best way to update the front end for my users. Some of my users will have their own queries, reports, etc., that they have built themselves into their local copy of the front end. When I upgrade the front end, I do not want to wipe out...

OOPS I described it wrong. The mainForm is a subform on a ParentForm. And the ParentForm is the one that the button press opens. So when I open the ParentForm or the mainForm by themselves the subform works fine. It breaks when the ParentForm is opened via the button press.

Thank you for the suggestion. I have done this and another issue popped up. The main form is opened by a button press on another form. When the button is pressed the main form loads but the subform is blank. I put a break in the subform's load and open events and the execution never went...

Write to one table from a form, view associated data from other tables on same form I remember reading on this forum that if you try to access several tables from the same form then you cannot edit any records from the same form. This is what I need to do: Use a form as a data entry form for...

OK, there must be a bug in Access. I rewrote the query exactly as before and now it is not truncating anymore. Don't know what to make of it.

This is the query I'm using: SELECT DISTINCT t_Table1.[AssetNumber], t_Table1.DESCRIPTION FROM q_Query1 INNER JOIN t_Table1 ON q_Query1.[AssetNumber] = t_Table1.[AssetNumber]; q_Query1 is a query which only returns AssetNumbers. The [DESCRIPTION] field in t_Table1 is a memo field. It...

Thank you Wayne. I found a piece of code that contains the SQL in the subform in the On Load event. I incorporated the new field in the SQL and it is working.