Search results

Hi Folks, This is a bit confusing, so I am going to try to explain with some examples and I hope someone can help me. If I were to load a nice normal standard flat file with the information I needed, that flat file could easily be loaded and would contain perhaps the following fields in say a...

Hi Folks, In preperation for converting non-profit health care information flat files from a easy delimited structure to a new federally mandated structure that is filled with dozens of loops/groupings, I am getting a temendous headache. My attempts to search for any help in terms of code...

Hey Folks, I noticed a particularly odd error with a database that I have been given the chance to update with a new version. I have pretty much updated the new version with everything I can think of except this one: Sometimes, for whatever reason, a client will be admitted prior to the...

Hi Folks, I have a set of queries that reside on a form ... everything works fine, but it seems like Access decides how large or small a column width is when the queries are automatically ran in the form. Is there a way to have these columns automatically grow to the point where all the data...

Hello Folks, Part of a small search form I have has two text boxes, one for last name and one for first name, along with a command button to execute a code that search for any matches based on the last name or first name a user enters. The code works perfectly and if a user enters the first...

Folks, I guess I just set the primary keys on the necessary fields on the SQL end and that way when the DSN-less code is run, it carries them over ... so problem fixed! woo hoo! Thanks! It still would be neat to know how to manually set stuff like this while using a dsn-less code thou...

Thank you ... I did get the code to work, but now I have another issue. I am essentially dsn-lessly linking three tables, two do not have primary keys and no manipulation is allowed by the user; however, one of the tables does have primary keys and user manipulation is required. When manually...

Hi Folks, In building a access front-end that uses linked SQL Server 2008 tables, for testing and development purpose I used integrated security with ODBC DSN and then linked the tables I needed to the front-end selecting primary keys on the tables that required it for data entry to be...

Hi Folks, I am trying to lock down a MS Access front end that links to a SQL Server back end. I have a Autoexec running at open of database that pretty much prevents the user from doing anything that I don't want them to do, I disabled the ribbon and all the menus and pretty much everything...

Hi Folks, I have a name that is formatted in the following manner: LN; FN MI Example: 1. Smith; John Q (person has middle initial populated) 2. Smith; Jane (person does not have middle initial populated) 3. Jack III, Citizen (person has suffix after name with no middle initial...

Hi Folks, I am comparing two data sets for integrity and compliance and using the keys of unique individual number identifier (primary key) along with date of admission, I am finding that between the databases sometimes the only difference is a date of admission difference between a few days...

hey folks, I am trying to run a query on sql server using the query analyzer ... the query works just fine, but I am attempting to IGNORE any instance where a unique identifier has a sum of units less than zero, and the query doesn't seem to do that: select provider, fiscal_year...

Binding a combobox to a dataset and value changes appropriately for current record selected? I have a dataset in a vb.net form that is linked successfully to a sql server table with fields from the table being displayed on the form appropriately. I have created a combobox and populated it with...

Hi Folks, VB.NET 2010 I used a wizard to create a dataset bound to SQL Server (it created all the necessary components such as the bindingsource, tableadapter, bindingnavigator, and tableadapter manager). I dropped the datagrid on the form and when the code is ran the datagrid is automatically...

Hi Folks, I wrote this code below that renders no error when ran; however, it does nothing. Ideally, I would like the code to display the data in the table on the form ... I don't get what I am missing. I am just starting out trying to create database apps in visual studios .net 2010 using...

Hi Folks, Just wondering what are the major differences between creating a front-end in access compared to a front-end with Visual Basic, .NET, and ASP on the web. It seems to me that many folks are fixated on .NET and ASP and don't realize that MS Access is very powerful and is capable of...

Thanks for the help! The current code is below. I went ahead and added a sort to the query to ensure the previous and current values that get compared have been sorted properly first and foremost. I also created a new RecordSet to accept values and write those to a table where a difference...

Hi Folks, I could use a little help with writing values for code comparing current and previous values ... The code is below: Option Compare Database Function runcompare() Dim rst As Recordset Dim dbs As Database Dim querystr As String Dim qryprev As String Dim qrycurrent As String Dim...

Hi Folks, Wondering if someone can help me with the necessary structure and/or keywords to get this rolling. Assume I have a base table in access, the table is sorted in a particular fashion so that logically you can step thru the records comparing the current record with the previous record...

I am trying to display something like 123 Lavage 123 Extraction 123 Lavage 123 Removal from 123 7/1/09 Lavage 123 8/1/09 Lavage 123 9/1/09 Extraction 123 10/1/09 Lavage 123 11/1/09 Removal the procedure lavage, for example, occurs back to back so I would only show that procedure once...