Search results

I am trying to help some one with a DB but I have limited experience in Access VBA or DB's, I had thought it was a VBA problem. Thats what I get for thinking. ;) Here is the dilemma. the user opens a form (DAHM-A TOOLS DATA), selects "SEARCH", this opens another dialog where you can enter a...

I read this line a lot in posts and I dont fully understand it. I'm as normal as they come, unless you ask my mom, she says I'm an alien. :cool: What does this mean to databases?

I am having trouble with syntax for a DLookup. Private Sub tbJobNo_BeforeUpdate(Cancel As Integer) 'Get the Pk value of the Job number in tblJobs lngID = DLookup("pkJobID", "tblJobs", "txtJobNo='" _ & Me.tbJobNo & "'") 'Now check if the revision value entered exists for that _ Job...

I use practically the same code for a textbox that I do for a combobox. Due to my inexperience, I dont know why this wont work. Textboxes: Private Sub Check32_Click() If Check32.Value = True Then varSettings = GetSetting("GeoMeasure", "CMM Data", "sPartNumber") If varSettings = "" Then...

On this page: A Beginners Microsoft Access Tutorial http://www.access-programmers.co.uk/learning2/tutorial.htm The tutorial takes you through some steps Step 1: Creating a blank Microsoft Access Database http://www.access-programmers.co.uk/learning2/tutorial-creating-blank-database.htm Step...

Attached is a DB. It is small and has a few forms. I am using this to teach my self some DB design and programming. I have good practical experience with VB and VBA (90% Excel). The intital DB design special thanks to jzwp22. The form "DataImport" is finished. (jzwp22) The form "tblJobs" is...

(Solved) Using the Registry. How to know if Key exists? This is a sample structure. The text in orange is the AppName, the text in violet is the Key. Writing to and reading from the registry is easy to do, determining if a "AppName" or "Key" exists is not so easy. In this case the string...

I have four textbox's, the first sets a value compared to a table. If the value entered match's a value in the table the user advances to the next textbox. The value entered in the next textbox needs be evaluated to the relationship of the previous table. Textbox1 = Part Number TextBox2 = Part...

(Solved) Using a textbox on a form with a table Hi, Im quite new to Access and database design allthough I have practical VBA and VB experience, I notice I dont have enough to do minor techniques in Access. :rolleyes: I have a textbox on a userform that a user will type in a value and I would...

Please explain how this works? Can some one help explain how this works? If that some one has time to add notes to the code. ;) It works as shown, I'm just not sure how or what happens to the Excel object being created or used. Hopefully, if I understand it better I may be able to modify this...

Can I use an excel worksheet (workbook with 4 sheets) for my access reports instead of redesigning them in access? It would be a time saver for me if I can, I already have modules within excel to populate the sheets with my data.

The code below imports my text file, but it ignores most spaces leaving me a useless table of concatenated data. The text file is space delimited. DoCmd.TransferText acImportDelim, , strTable, strInputFileName, False How can I import a text file space delimited? I have no problem importing a...

The snippet of code below should add a new line to the table "tblPartRev" but it doesnt. I think it has to do with a foriegn key in that table. The table: tblPartRev pkPartRevID fkPartID txtRev myrecset1.Open "tblPartRev", , adOpenDynamic, adLockOptimistic...

I am too new to figure this out. (Code was supplied by a member of this forum, thank you for all your help ;) ). In the code below it errors on one specific line in Red. The line in Green I added, seems there is/was a missing end if. Best assumption of where the end if should be. :rolleyes...

(SOLVED) How to get filename from string? The code below is a snippet from this forum (Thank you). I am trying to get the file name (remove path) from the variable "strInputFileName". The path can vary, the drive will always be a network drive but could someday be renamed (you know how those...

I have a db with several tables and now I need to import data from excel csv files. (Thank you jzwp22) Typically, like in excel, I record macros for the import process and modify for my needs but it seems that Access doesn't have this option. My 1st goal is to import a spreadsheet (I think I...

I do not know how to begin a database based on the data I have, see attached txt file. I had thought I could import the data from a text file but I am not finding an option to do so. Do I have to import into Excel and then to Access? (Excel is easy for me as I know it well including VB.) FYI -...