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

What The Heck?! Rich, What are you referring to? Autoname?

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

Here is what I did: Private Sub btn_AssMTSNum_Click() On Error GoTo Err_btn_AssMTSNum Dim curDate As Variant, curYear As Variant Dim Assign As String Dim newRec As Boolean, dirtyFrm As Boolean Dim rst As DAO.Recordset, test newRec = Me.NewRecord dirtyFrm = Me.Dirty Set rst = Me.Recordset...

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

Missingling, You just reminded me of something. Forms have a limit of how many 'objects' (buttons, lables, textboxes, etc...) they can have on them... And even when you 'DELETE' some, you have still used up part of your alloted amount... This form that I was having problems on I have copied and...

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

The BOSS has a special front end with full access to tables, can click a button to show JUST the records that have been 'deleted' and SHE can do the actual deletion...

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

Tag Property? Rich... Can you be a little more specific? I have utilized the TAG for holding values in Forms before... But never in Reports... What do you mean?

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

iif([FieldOne]=[FieldTwo], 1, [FieldTwo]-[FieldOne]) Got it... I shoulda looked around first... Sorry all...

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

Long Time No Answer... I asked that question 3 years ago... chuckle... I already have the answer... That was funny, I got an email saying I had a reply to a post on this forum and I wondered WHAT POST ARE THEY REPLYING TO??? wow... Thanks for the answer tho man... It's nice to know people are...

Monday... Um, I spoke too soon. I am going to be adjusting the code in question either tonight or tomorrow. Let me get that adjustment in place and THEN I will send you the updated code. The GetMasterVersion function is NOT working in Access 2002, so I am going to try a table based idea, I have...

Lite Version... It's Sunday... I will try to piece together a well documented/commented version by tomorrow... or even a Lite Version to help ya out... I understand it can be annoying to work with code you never read...

Kinda... They do look similar gibson... And whereas I might not have phrased it quite so harshly... I have to agree with the message... It's better for you AND for anyone with the same problem if you don't multi-post across several forums with the same problem... It makes it easier to look...