Search results for query: *

Hello All, I have this bit of code that was derived from a lot of help here (Thanks AceMan1) and it works great on a main form but for some reason when I try to run it from a button on a main form, for data in a subform I get a Compile Error: Expected Function or Variable. When I compile the...

Hi All, I'm trying to trim down my code and am creating master funtions to aleviate redunancy. I have a Sub that I want to have a variable that names another sub I want to run: Sub NewRecord(NameofOtherSub, etc, etc) If something happens then NameofOtherSub End If I don't know if it...

I have a database that uses all unbound forms as it was the only way I could take total control of everything, it works fine but I have a few sub routines that I think could be better made to work with any form. As it is now, I have to code all this for each form. Any suggestions as to how I...

I'm doing a freebie for a non-profit and since it is an organization for the visually impared, I'm trying to validate to strict. For some links on a page, I want them to open in a new window so I used target="_blank" which of course doesn't validate to strict. Is there some other method open a...

I knwo this must be real simple but I just have never tried it and can't find anything in a search. I have some forms with a to and from date fields for criteria. I would like to make some buttons such as This Year, This Month, Last Year, Last Month and write some code that will simply fill in...

Hello All, I've been using access since way back in v1, I'm not a programmer but I have written several applications for different companies that have worked well for many years. My best efforts have been using unbound forms and code to update, edit and save records. With bound forms there...

This really seems basic, but I can't seem to find anything about it. When I'm using notepad for some JS or even HTML, sometimes when I save it, it just runs all the words together and takes out all the formatting (just linebreaks and indentions). It doesn;t happen all the time and it's happened...

I just learning Javascript from snippets of script here and there and am adapting a cart system I found to my website: I've seperated the areas I have questions on with red. I've tested this script and it works great as is, I just need to change some things dynamically. Thanks in advance for any...

Hello All, I have a shopping cart I'm working on for my website and I have a table with 2 cells side-by-side. The first cell has a picture, the second a form with print sizes, pricing etc.. I decided to build this table with JS because I have some pricing and discount structure in a JS file...

Hello, I have some code that I'm trying to make work. What I want it to do is Open a query that selects orders based on a query that gets dates from a form (Finally got rid of that pesky 3061 error!), runs through the recordset, grabs each order # then runs through the Order Items table and...

Hi all, I have a piece of code that I'm just stumped with: Dim OrdIn As Database, Invoice As Recordset Set OrdIn = DBEngine.Workspaces(0).Databases(0) Set Invoice = OrdIn.OpenRecordset("qryInvByDate", dbOpenDynaset) The qryInvByDate is a simple query with 2 fields, the date field has...

Hello, I have some code that runs on a payment form that goes into my Order Table and marks paid to true or false based on the payment amount subtracted from the order amount, here is the code: -------- Dim PdI As Database, PdOrd As Recordset Set PdI = DBEngine.Workspaces(0).Databases(0) Set...