Search results

Good morning, Hope everyone is well! It has been a while! I have a report where I need to be able to show an enormous amount of data. I store the data on a SQL server, using Access 2013 on the front end. SQL has all the data (41 pages worth), but the report in Access only shows about 30...

Thank you everyone - I think I have figured out a work around that might alleviate the issue. The "need" for the repeating text is because the report is required to have the most recent documentation prior to adding any new documentation. Unfortunately this can lead to longer text boxes. I...

Okay - I can't figure out what is wrong with it then. I have the box set to long text on the access side, nvarchar(max) on the SQL side, and it will only take the approx 160k characters and no more. For your box that has almost 500k in it, you have the same settings? The reason I need a lot...

That's the issue - the text field will not take more than that. I had the field in SQL set to ntext, then changed it to nvarchar(max) as I read that ntext was deprecated and that nvarchar(max) was the correct field type to use. Can I ask how you made your window in your post? Was that a zoombox...

Good afternoon, I have a long text box on a form (nvarchar(max) on sql server back end) that I need to be able to handle unlimited text input. Currently it can only handle around 160,000 characters. As I inherited this part of the db, I am not sure how the previous person made the box (the...

Of course...sometimes it is the simple things. Thank you. Still stumped on how to pass the variables back to SQL as parameters to the stored proc.

Good morning, I am not sure if this needs to go here or over in the SQL forum. I have the following Stored Procedure: USE TestDB GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[getLogin] @StaffName nvarchar(25), @Password nvarchar(25) AS BEGIN SET NOCOUNT on...

vbaInet - the short of it is that there are lots of records that are tied to the "old" numbers that cannot be changed. Thousands upon thousands that are identified on the hardcopy by the auto-number ID that is already in the system. Since there are gaps, if we went to purely a Dmax+1 system, 1...

Good morning, sorry for the delay in getting back to you all. The way the system was setup, before I inherited it, was that the auto-numbers were being used for identification of hard copies of files. Since there are many gaps in the numbers, we cannot reset them to do our own auto-increment...

Good afternoon, We need to reset the autonumber after the last record is deleted. For example: 2006 2007 2008 if 2008 gets deleted, we want the autonumber to reset back to 2008 rather than move to 2009. Is this possible? This is the code we are using but cannot get the string to recognize...

Thank you, I will give that a shot.

I have two tables that I am combining together. tbl1_combined has all the newest information. tbl2_import has the old information. I have a column, census, in table 2 that I need to get into table 1. table 1 is structured a little weird, but here is what it looks like Contract Number...

vbaInet The process is that they select a contract number on a different from, it opens the form with the above information which is only tied to that particular contract number, they cannot change the record or do anything other than select team members in the combo box subform then they must...

That did it! Thank you very much!!!

That gives me the contents of the listbox in the combobox. What I need is the opposite, I need everything BUT those items in the listbox to populate the combobox.

Hello, I have a list of staff that have a conflict of interest with a particular entity. As a result, these staff are not allowed to interview these entities. I have a query that matches all staff with their respective entities that they have a conflict of interest with (CoI) and that is...

I must have been reading your mind Paul, thanks!!!

Fixed it! "', #" & b & "#, '" By adding the pounds/hashtag in the code string it forced a date recognition.

Hello everyone, I am trying to add 30 or 45 days to a certain date and insert that date in a table. The field is declared as datetime on the SQLServer and has been tried with all date formats, and none, on the access side. The problem I am encountering is that the date is being inserted as...

Well, I figured out a way to do it. It works, but it is slower than I would like. Instead of using a pass-through query, I just use an append query. I use pass-through queries to truncate the tables, then the append queries to repopulate them. Made a macro (using OpenQuery) to run the...