Search results

Greetings, I'm wondering if anyone knows of a way to connect to a SharePoint list without using Linked Tables. I know... sounds wonky but I assure you I have good reason. I've tried using a basic select query with this as my connection string...

Ok... I'm stumpted. This is driving me crazy. All users are using Access 2003. Some users have Excel 2003 and some have Excel 2007. I have a parent-form that has a subform that needs records to be manually pasted into it from Excel. To accomplish this, I have a button on the parent-form...

I'm so frustrated with this pesky issue and I'd love it if someone could help me out. I've got a query where I want some criteria to pass from a form's control. If the forms control is blank I want the query to pull all records. The field in question is a date field. I've tried all the...

Greetings, I use the code below quite often to sort a continuous form based on click on buttons that act as column heads. Private Sub ColumnHeaderMemo_Click() 'This will sort the form based on a label click. If Me.[Memo].Tag = "desc" Then Me.OrderBy = "[Memo] Desc"...

Let me preface this question with... I DID NOT CREATE NOR DO I HAVE ANY CONTROL OVER THE FILE I'M NEEDING TO IMPORT INTO ACCESS. I've got a situation where I'm needing to normalize a delimited .CSV file on a routine basis. The .CSV file has 369 fields. When normalized correctly, the true data...

I was wondering if there is any way to prevent the "Windows Media Player" ActiveX control from autostarting. I'd prefer to have my users press the play button. If anyone knows of a way I'd appreciate the heads up. I found a thread...

Greetings, I've seen the gHudson thread that explains how to backup and zip a database. However, that code must use WinZip to work. I was wondering if anyone knew how to perform the same task (backup and zip) with the "compressed folders" function built into windows. This would be a great...

I didn't think this would be such a big deal but gosh... I have a very simple form based off of 4 fields from a table and 1 calculated field: Field 1 (text) = ProductName Field 2 (double) = UnitCount Field 3 (double) = BuildingCount Field 4 (memo) = Notes Field 5 (calcualted) =...

This post is meant to help others. I have already solved the problem but was unable to find a solution anywhere. Therefore, I decided to post the solution in case anyone has the same problem in the future. This is what you're about to see in code: 1) I have three cascading combo boxes 2) I...

I sure am having difficulty with this. I'm trying to have the criteria in my form refer to a text box within one of my forms which is the text as I would write it myself within the query design view. Query's [DEST_ZIP5] criteria = [Forms]![Mainswitchboard]![QueryWizard].[form]![calcDestZip5]...

This is more of a curiosity than anything else. I was trying to figure out a way to convert numbers to text strings for various reporting purposes; example below: 1 = One, 1st, First 2 = Two, 2nd, Second 3 = Three, 3rd, Third etc... It didn't take long for me to decide to bag this challenge...

I've tried and tried and tried to get a DLookUp to solve this problem but Im having no luck. I'm thinking a query in the record source or a cleaver filter of my subreport may solve it but I wouldn't know how... here's the problem. I have a report based off a table called ASSOCIATIONS. The...

Can someone help me fix this... I'm just trying to create an Option Button that will Lock/Unlock a SubForm upon change. I've seen and read many other threads on this topic but still cannot get it to work. Other threads recommended adding/changing the tag on all the forms controls. I thought...

Alright... I'm no programmer. I dabble in Excel and Access VB but that's about it. Recently my users demanded a calculator for my database and found one on MVPS.org (http://www.mvps.org/access/resources/downloads.htm). That works just fine... but it sparks a thought... Many of you are...

Hello. I've searched the threads and Google and have not come up with a solution to this; let me explain. 1) I have a continuous form 2) Each record in the continuous form has a cost code associated with it. This cost code is in this format ##.###.### 3) The numbers in the cost code have text...

I'm bewildered by the fact that I can't seem to find any threads on this... Nevertheless, I am trying to create a report from my Access Database that will list my records (up to 20) in the header of my report. Then, in the details section you would see all the field names on the far left...

I'm sure hoping this is possible. I have a report with two subreports. It works perfectly. It does just what you'd expect a report to do... print data from my database! Now, the same report could be used as a HARD COPY form for my coworkers to fill out long-hand. Then, they could turn the...

:confused: I've searched and searched... I can't seem to find anything close to this. I have 10 sets of fields: [Photo01date], [Photo01], [Photo01note] [Photo02date], [Photo02], [Photo02note] [Photo03date], [Photo03], [Photo03note] etc... These 10 fields are shown in my form for entry. There...

I've created a form. Within that form I have an image control. I am using this code to pull the corresponding plant image from a folder filled with JPGs. It works just fine except one thing. When I change from record to record my cursor jumps to the center of the pulled JPG. I don't want my...

Alright people... I'm ashamed to even ask but here goes. I have two tables: 1) Employees 2) Neighborhoods Table Employees has a comprehensive list of all employees and their information (including phone numbers). Table Neighborhoods has lots of information about each neighborhood we're...