Search results

Alrighty then... I have a question for the db designers out there. I am looking for some ideas, guides, opinions, etc on a db I am trying to put together. Technically, this has nothing to do with Access. In fact I am designing this in a MySQL db, for a web-based application. Here is what I am...

I have been coding in Access since 95, but I stepped away from Access and learned the OOP concept in languages like PHP and Javascript... Now I would like to apply the concept to Access db's I am working on. Does someone know of a good online site for learning VBA OOP??? Help if you can... thanks!

I currently work for City Government and am involved in a project where we are designing a Roofing Maintenance / Building Management database. We are using Microsoft Access as our database program of choice. We had originally shopped around and it was decided that we could create a more...

I am looking for the code / patch / add-on / whatever that will allow me to take a MDB database and generate the SQL code to replicate the database tables / joins / etc... in a MySQL db? Surely SOMEONE has done this already...

Alrighty then... I have searched around the site, albeit not to the very tips, but I did dig through several pages of searched-out-content and found nothing related to what I was looking for. What I have is a DB that I work on at my home or office for a client. I set the paper-size to Legal and...

Ok. I have a form. The purpose of the form is to generate a new report. The user opens the form. Selects a Client and a Borrower. The user presses a button that assigns the REPORT NUMBER. The number is SUPPOSED to be based on the Primary Key for the table the form is based on? However, for the...

Alright... I have been working with Access for about 8-10 years now... I am very competent with designing forms and working with VB(A)... But I cannot for the life of me understand something... I just built a form, fresh, and no matter what I did... If I went into VIEW mode for it, I got a...

I have built my tables with two extra fields. del_Rqstr - Username of person requesting deletion of record de_Rqstd - CheckBox (Record Requested To Be Deleted) The reason is, my client doesn't want her users to ACTUALLY delete stuff. She wants to be able to see who deleted what and when. What I...

Ok. I have a mowing report. There is a date field that shows when the MOW job was done. I have another field that needs to show the amount of time that elapsed between one job and the next... For instance... [mowdate] - [daysbetween] [1/01/2004] - [0] [1/07/2004] - [6] [1/14/2004] - [7]...

I have never had to do this, and so I am stumped... I have two fields... Field One:: Day the request was called in Field Two:: Day the request was satisfied How do I add a field on my report that will calculate the days between those two? I don't care about workdays versus weekend... But if...

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

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

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

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

Got the answer... Private Sub Command0_Click() Dim intIndex As Integer For intIndex = 0 To Forms.Count - 1 If Forms(intIndex) Is Me Then MsgBox "My Index is = " & CStr(intIndex) Exit For End If Next intIndex End Sub Got it from another...

I had a couple questions for whomever can help... How would I get the Index of the Current Form Is is true that as I open a Form it is assigned an Index Number ONE greater than the last opened form? I am trying to setup my buttons to do the following: 1) You are in a form 2) You click...

Ok... I have a form based off of a table. The table has a primary key called rpt_ID The Primary key is an Autonumber. While in a NEW Record, I need to grab the rpt_ID number... However, since it is a BRAND NEW RECORD... the rpt_ID is not set yet? What can I do to get the rpt_ID WHILE in a NEW...

Ok. I have a table with three fields... [fld_City] [fld_State] [fld_ZipCode] I have a combo-box on my Entry Form IN the ZipCode field. The User types in a ZipCode. At this point... I want the City and State fields to auto-fill... I tried a couple functions similar to: Public Function...

Ok... I have seen this done and am HIGHLY irritated that I can't find it on this board... Heck, I have DONE this, and I can't remember... What I want is: I have a textbox. Unbound. I have a listbox. RowSource = SQL Code I wrote I want the listbox to JUMP to the first entry that matches the...

Question... I am working on a data-app for a game I play. Alot of the Files use UINT32 formatting for structures of data. What I would like is to create a Form in Access that will open up a file, parse through, drop data from the file into Fields in Various Tables, and then I can work with the...