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

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

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

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

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

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

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

Hello all, I am sorry if this question has been answered, but I have had no luck finding a concrete answer to this question. Or I am not asking/searching for the question the right way. I have 3 text files, I receive daily, that I need to import into my database. Until we upsized to SQL, we...

Good morning all, I have a form that contains a listbox that a user can select multiple items from, and that listbox will then populate a subform with those selections. There is a combo box with multiple outcomes for those selections, in the subform, and all selections must have an outcome...

I have a list box with a select few records in it that when a button is pressed, the contents are displayed to text boxes. It partially works, but the problem I have is that the loop only picks up the last record added to the list box. I have included the code below, changed some names to...

I have a several fields, calculated, that break apart a string of text at every open and closed parentheses. They work like they are supposed to with no errors. However, I want to use the result of this particular field in a combo box to populate another combo box with the other half of the...

Hello folks, hope all is well. I am working on a report that has some special characteristics and I need some help trying to figure it out. The explanation is a bit long, so I apologize in advance. Let's say I have a list of groups of Vendors in a table, complete with VendorID. I have 3 other...

Good morning! We have a survey form we are trying to get some information from, and I think I need a loop to get the information, but there isn't a ton of information that I have found for what I need to do. I have a six question survey that has a range of answers and a comments section (I...

Good afternoon! I am attaching a picture of what I am talking about as this is going to get confusing...at least it is for me. I have a Navigation Form that holds 7 tabs that pull reports or data entry forms. I am trying to get the Preview Selected Record function to pull the UniqueID field...

Hi folks, I have been trying to figure this out for hours and I cannot seem to find my error. It is a basic login vba that I have put together from looking at examples here and other places. I used the dlookup to find the UserName, Password, and Password Checkbox values in the lutWSCStaff...

Good morning, We have a navigation page with 5 tabs and several navigation buttons underneath their respective tabs linking to reports. In the main part of the navigation page we have 17 search parameters (text boxes and combo boxes)that the user can use to sort through all the reports we have...

Hello all! I have a navigation form that will have 6-8 tabs. We were using about that many databases, but we are finally consolidating them into one. The result of us using so many databases has been the multitude of forms and reports that were necessary for each database prior to merging them...

If this is covered elsewhere, I could not find it. I have a form that generates a .PDF attachment in an email. When Outlook opens the email, ready to be sent, it prevents the user from doing anything else with Outlook. They cannot click through other emails or copy/paste other attachments from...

I have searched several times for a solution to this problem, but can't seem to figure out what the issue is. I have code (copied from here and the MS-Access how to) that has a hidden form that loads on the db startup. Attached to that form is code that is supposed to check for a file, if the...

Not sure how to even ask the appropriate question (don't know what I don't know), but I need help. We have three text files that are pushed to us every night. We currently have 8 different databases (some are significantly smaller than others) using the same the three sources tables in addition...