Search results

Great! The next thing you need to do is have a Patients' Detail table. That's where you store their info ONLY, no snacks, entries nothing. Then you can have a one to many relationship (One patient Many Master Lists). I would also make a separate table for OrderedSnacks. Many-Many relationship...

Likewise! I can never justify buying anything off the shelf simply because I like challenging myself to make it, and let me tell you, the satisfaction when done is simply addictive! Welcome aboard Jacob.

Oh my bad, I was under the impression it was 2012 and everyone had a version of 2007 around them haha Here's a screenshot of an mdb I just created. Literally, all I did was create it, new form, blank text box, paste and BAM! Here's the DB:

I already posted it in post #7, check it out.

Great stuff! That's how I discovered this site too. Do you work with Access a lot?

A few things to not: 1) You should only have one table named Snacks, with a field named "SnackType". That's where you enter 10AM, 3AM or HS. 2) The master list should have a snack ID field where you enter the snack, not the other way around. You need to adjust your relationships. Once your...

A form is not meant to be printed sir. You should ONLY print reports. It can be customized easily to your liking.

I'm assuming you're referring to it's title? It's the 3rd argument in the msgbox function MsgBox(prompt, buttons, title, helpfile, context) More on msgbox here: http://msdn.microsoft.com/en-us/library/aa445082(v=vs.60).aspx

Weird, can you post your database or a sample of it where this error is happening?

That is what I have already established sir. My question is, is there anyway to increase that limit? What about a string variable? Does that have an upper limit too? Maybe I'll just save long strings in a .txt file and import it using vba?

I tried both, setting the field to unbound (no need for table) AND linking it to a MEMO field. Both yielded the same error.

What I would do is, add a Yes/No field to the table named: "Honored", and upon insertion of the date of a new appointment, I would check using to see if it matches any previous NextApp. Here's how to do it using DAO: Private Sub AppDate_BeforeUpdate(Cancel As Integer) Dim rs As DAO.Recordset...

Yup, they're called Union Queries: select * from table1 union select * from table2

Strange.. Can you do it here:

Well, view the HTML Source of this page for example, copy it and paste it in an unbound textbox in a form and see what error you get.

I keep getting this error: "The text is too long to be edited" Everytime I paste long html code into a textbox.

You forgot to paste your SQL Statement

One way of doing this would be having a table named Grades with three fields that looks something like this: LowerLimit UpperLimit LetterGrade 940 1000 A 900 939 A- Then using dlookup to retrieve the letter grade: dlookup("LetterGrade","Grades","LowerLimit<" &...

Is there a way to increase the maximum allowed characters on an unbound textbox?

I don't quite get why you're adding a 3rd and 4th subforum in the same form? You'll need an OrderNo form linked to Orders Subforum via OrderID. Once that invoice is input and saved, you should move to a new record to add the next invoice. Unless I'm missing something?