Search results

Oklahoma is Ok Yeah, this pitiful wreck of a bankrupt state still has that on their license plates... chuckle... Good Lord I can't wait to move 'home' to Ireland... As for your other comments... I didn't check the MSKnowledgeBase because the Error Messages seemed rather straight forward...

Re: Better example, I hope Ok... Let's see if this helps... When you say Continuous Subform, I assume you mean that for each Parent_Item (from FORM) you can have unlimited Child_Items (from continuous subforms)...? If this is the case, I am lost, I just can't visualize it... As for your...

Well, you see... They lose it... ALL of their individual changes... Yes... Sorry... I am stunned, my users are all Engineers... NONE of them know HOW to make changes... I have never had to deal with that issue... chuckle... Well, the reason is... See the Back-End has ONLY Tables... The...

HUh? Ok... I have read your post again, trying to look at it from another angle... It looks like you might be working with a subform in DataSheet View... If THAT is the case... Then what you are doing is entering a record in what you call LINE 2... and wanting it to do something based on...

HUh? Ok... It sounds like you are stumped... It sounds like you have tried some ideas to make this work... What it doesn't sound like is that you can explain easily your problem... I don't EXACTLY understand what you were trying to say... And hey, that's ok... I usually speak gibberish for a...

chuckle Jeez, YOU didn't read my post didja? huh huh? just kidding... Check out this code: Option Compare Database Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Public Const ERROR_SUCCESS As Long = 0 Public...

Kraj: Hmmm... I did some searching... I have had calculated text-boxes in the past that I wanted to trigger certain items... So, I went to the OnChange event of a text-box on a Form. Here is a note that directly speaks to your problem... Setting the value of a control by using a macro or...

plucnik: Try This... I can't guarantee that this will work for what you need... BUT... it might... Since you can't have more than one person in a database AND be able to make objects via code... Have you considered trying a front-end / back-end approach? I use this on almost ALL of my...

Ok. Here is the problem. I have created a database. I have a front-end database that is filled with Forms, Reports, Modules, and Macros. The only tables that the front-end database has are LINKED tables to what I call the back-end database. The back-end database ONLY has tables. I then go one...

Eh Surely SOMEONE can help...?

Here is the code I have so far: Public Function GetMasterVersion() As String Dim wrkJet As Workspace Dim dbs As DAO.Database, cnt As Container Dim doc As Document, prp As Property ' Property not found error. Const conPropertyNotFound = 3270 On Error GoTo GetSummary_Err...

Heya... Hey DocMan... Yeah, actually I am opening up binary files and grabbing strings and placing them inside fields for temp storage. I am trying to write a data-app that will grab data from specific files and adjust and manipulate the data through forms, then plop it all back up into the...

My Recommendation What I have done is this: I created a BackEnd database. I called it: BE_MTS.mdb This is because the database was built for a company named: Midwest Title Services and the BE tells me it is the BackEnd I put ONLY Tables in this Database. THEN: I created a FrontEnd...

Sample of my Dilemma Private Sub btn_ExcelMessAround_Click() Dim objXL As Excel.Application Dim objWkb As Excel.Workbook Dim objSht As Excel.Worksheet Dim FirstRow As Long Dim ThirdRow As Long Dim sSQLSearch As String Const conSHT_NAME = "Special Projects" Const conWKB_NAME = "C:\My...

Query: How Do I Hey, while we're on the topic... I am wanting to port some data out of a database INTO an Excel Spreadsheet... Using the code in your dummyfunction, how would I: I want to label some columns... Column 1: FundNumber Column 2: ProjectNumber Column 14: ProjectDescription ...If I...

In the Help files I came across this: Memo Lengthy text or combinations of text and numbers. Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the...

Excellent... THANKS! That did it... I wasn't thinking, I was trying DAO with TableDefs and everything else... ugh! Too much on the ole mind to code... Ah well... But thanks alot man... That did the trick...

Greetings one and all... Just a quick question for the masters... If I am using DoCmd.RunSQL to INSERT a record to a table. And if that table has a Primary Key with Autonumber. Is there ANYWAY to INSERT that record AND grab the Autonumber generated? For instance... Let's say I have a Customer...

Create an Option Group. Name it: opt_Salutation If you use a Wizard it will create the Options for you. Otherwise you need the following Options: Check Box: opt_Mister Option Value: 1 Check Box: opt_Missus Option Value: 2 Check Box: opt_Doctor Option Value: 3 Now, I created a Textbox to...

<scratches head> Not sure how this ended up here... I WAS replying to my own post where I asked how to do what is done here...