Search results

While themurph2000 help you with this certain DB try also to help itself by reading about databases; what are and how it works. Start by learning about normalization. After you will fully understand this concept will become a lot easier to design DBs. Here is a very good article: Database...

Welcome Stefan ! Seems that we, all, have Access as hobby. About fishing... this is far away of my interest area :)

What about to use "RateAsDecimal" (without quotes, of course) as the field name ?

It is hard to explain. There are a lot of things here. The solution seems to be: 1) the form should Allow Addition but don't Allow Edits (or Delete) 2) You must set as "Default" for all fields (in fact, controls) the value that you find in the "last row". I quoted the "last row" because here is...

Not sure that I fully understand your initial post (because my English). I think that the best deal is to unify that "20 weekly timetables" in a single table (easy to do, with a bit of code, in Excel) then use this single table in order to develop the DB in Access.

Take a look here, maybe will help yo. http://bytes.com/topic/access/answers/932581-discussion-fully-customized-export-data-access-excel

Unfortunately I have only A2007. But there are other members on this forum that use 2010 so, my advice is to remove all data from your DB and to post it. Maybe someone will find a solution.

I think that forms with subforms is what you are looking for. 1) Design a form (frmNotes) based on table tblNotes. 2) Design a form (frmIssues) based on tblIssues with frmNotes as subform 3) Design one more form (frmMain) based on tblMain with frmIssues as subform.

What happen if you copy a DB from the users computers and open it in your computer ?

OK. Maybe my English make a jock with me :) . Here: Beginner Advice for a Family Database - Access World Forums you will see a DB designed from scratch. I'm pretty sure that you will find useful ideas for you.

And I think that you don't. For example, the tblMonth is not necessary. If you have a date then automatically you can CALCULATE the year the month the week and even the day of the week. Also the 3 fields in tblMaster (2014,01 ; 2014,02 ; 2014,03) show me for sure that your DB is NOT normalized...

I think that I understand what you ask but also I understand that you don't know how the DBs work. So read this very very carefully: Database Normalization and Table Structures - Microsoft Access / VBA

Rectification: You can NOT create the text file. You can EXPORT as text file :) . It is not the same thing. Here (see the attachment) is how you can really create a text file. Hope this will be a help for you.

Oops Replace this If ADDRESS1,Text = "." Then with this: If ADDRESS1.Text = "." Then Not comma but point after ADDRESS1

The fields are Unbound... And this is the problem. In fact you have a SINGLE control (text box) but you see the image of this control many times. Do a test: Drag your text box in the header area of the form then fill it with data.

Sorry. Indeed, now I see. From my experience the single way is to recreate the form. Start to design a new form. Copy all the controls from the old form into this new one. Copy also the code. See if the problem persist.

Try this and see if work Private Sub ADDRESS1_BeforeUpdate(Cancel As Integer) If ADDRESS1,Text = "." Then If MsgBox("Do Not Type a '.' in this field without any other text", vbOKOnly) = vbOK Then ADDRESS1.Text = "" Cancel = True Me.CITY.SetFocus End If End If End Sub

Hm :) ctrler is a STRING Dim users As Control Dim ctrler As String Dim xx As Long .and a string can't be visible or invisible. So, if your text box is named also "ctrler" change one of this names. Good luck !

Insert a carriage return (chr 13) where you need.

I need to see your DB in order to try to help you. The DB as structure, not the info that you store in. So, remove all the info from your DB, then fill the tables with information like Person , Function , Age Jon Doe , US president , 4 then post the DB. Do not forget to keep the original :)