Search results

Hello, I have 2 tables that have matching studentIDs. TableA and TableB have a 1 to many relationship from TableA to TableB (with studentID). My idea is that for all the records in TableA, I have to save the studentID for that record and go to TableB with that ID and count the number of...

Not really, I want the user to choose the option from the combo box, and right after the selection text ends (inside the same combo box), I want them to be able to type in whatever they want in addition to the selection they choose. Thanks

Hello everyone, I have a combo box that looks at some values on a table (let's say "optionA", and "optionB". How can I make this box editable by the users on a specific record? Meaning if the user chooses "optionA" on a certain record, I want to be able to add " whatever" after "optionA", so I...

Hello, I want to delete many records in a CASCADING way, meaning if I have a 1 to many relationship between 2 tbls, I want to delete some records on the 1 side of the relationship as well as their corresponding records on the many side of the relationship table. I know how to do this in SQL...

Maybe you misunderstood. I am aware that the print view is what I will see when printing the report, but I don't currently have a blank page in between records, and that is what I want to add (blank page) actually. Thank you very much again

Hello, I have a report, and I want there to be a blank page in between records when selecting "Print Preview". I tried making the report as wide as I could to see if it would add a blank page and it did not. How can I do this? Thank you very much.

With that question you solved my problem. Really, really, really THANK YOU

Hello, When I select "Print Preview" for a report, it shows me an additional blank page at the end of each record. How can I get rid of these blank pages?? If someone can help me asap I would really appreciate it, since I have to send these reports out before the end of the day. Thank you...

This is what I have so far and it's not working. Am I on the right track? SELECT t1.* FROM tempAllStudents t1 WHERE t1.Start = t1.CYear AND t1.Qualified = "Yes" AND t1.[Student ID] = (SELECT t2.[Student ID] FROM tempAllStudents t2 WHERE t2.[Student ID] =...

Hello, I am having trouble writing the following query: All Students that in the first year were Qualified (Qualified=Yes) but the next or any following year were NOT Qualified (Qualified=No) This is the source table sample: StudentID StudentFirst StudentLast Start...

Hello, I am new with asp. I have to maintain a web site that uses asp. I have to update some text and add a link (within that text) on a page and can not find the page on the server. Users use a content manager to dynamically post info on the page. One of the form's fields of the content...

Hello everyone, This is a database someone else created so I do not know where exactly the code is. There is a button that when clicked, it does something (let's say open another form). Now the strange thing is that this button has no OnClick event or any other type of other event assigned to...

Hello, I already moved my tables from ACCESS 2007 to a SQL Server 2005 server database. I want to link the forms from ACCESS to the SQL database tables. In other words I want my application or forms to use SQL server and not the ACCESS back end file. How would I do this, because I really have...

Hello, is there anyway that I can attach a picture (company logo) to the text part of an email using ACCESS 2007 (VBA)?? Does the picture have to be in any special file extension?? I pasted the logo to a form, and when clicking on a "send email" button it opens the email window. In the code,I...

I meant to type ACCESS 2007 not 2005. Thanks

Hello, How can I get the Windows version that I have installed on my PC from ACCESS 2005 (VBA)? Thank youvery much

So then I apologize, I misunderstood. Have a good day

Had no intention to offend you neileg. I was just making sure that my scenario was well described, but thanks for your cute statement.

Thank you for the quick response There are 2 ranges, I just sent you one (RangeField1) for simplicity, but I do compare it with 2 ranges. The totalPackages is controlled and formatted somewhere else in the program since it can be a decimal so I am not having that problem. However, the "&...

Hello, I have a table called "ShrinkWrapBinding" where I am supposed to look up a "Price" from. As you see in the code below, I calculate a "totalPackages" number which comes from values in a form. My problem is that when I try to use this value (totalPackages) on the DLookUp function (as seen...