Search results

I don't know about the original poster but I can attest that this need persists with others as well, including myself. While many may offer various form views and subforms as possible options the fact remains that Split Form view has many virtues. Most significantly for me is the fact that...

Wow... did I really stump Access World Forums! :) Just kidding, I love this place. For what it's worth, I'm still stumped. Moreover, it's getting worse. It would seem that using Data Connections in Excel to an Access Database that has SharePoint lists linked to it cannot refresh...

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

I used this modification and it seems to work and solve for some problems with the previous logic. This modification accounts for IDs that may or may not contain letters. Explanation: Add a leading space ID. This coerces the ID to a string if it isn’t already. Replace all zeroes with spaces...

I made some tweaks for my own use. I made the table and field parameters. I also handled the direction of the dates (first>last, last>first). Take care. Function NetWorkDays(dtDateIn As Date, _ dtDateOut As Date, _ strHolidayTable As String, _...

Bob, You're a rock star. I'm so happy you saw my thread. The "Data Entry" option is NOT turned on; yes, I see a vast amount of other data in both the "Datasheet" and the "Continuous Form" views.

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

Brian, you rock. I've already subscribed to the link you referenced. That totally helps me understand filtering queries through form criteria. Thank you very much.

Thanks so much for your reply. Your comments are well recieved. Your ideas on renaming my forms to remove "-" and " " are correct. You idea to rename my control without "rpt" is also correct. Frankly, I don't know why I made such obvious mistakes. Rookie mistake. Anyways, I tried the...

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

Good point... however, I'm using Access 2003. Access 2003 has a limit of 255 fields. If I understand you correctly, your "treat it like a text file and parce it by hand" comment is what I'm currently attempting. First glance, it looks like it might work... just using a lot of "InStr"...

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

I'm trying to find the same thing. Have you figured this out?

Ahh... perfect! Thank you!

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

But you see, that won't work because [ProductType] is not a field in "table". In an attempt to create a normalized database I thought I could avoid duplicating the data if I just stored the product types under a seperate table. So, I just pull in [ProductType] based off of [ProductName]...

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