Search results

I'm in the process of learning how to create a custom ribbon bar for my DB. I figured out the basics and how to add and arrange existing buttons/commands and groups, but is there any way to add a button that runs a custom procedure? Well the custom procedure is very simple... just something that...

Thanks for the suggestion. In all honesty you totally lost me with that. But don't worry about explaining further. I was reviewing the code and although everything was working, my calculations were incorrect on how to count the inventory anyway. So I ended up rewriting the whole thing and...

I'm sorry, but I did include the VBA function/code that includes all the Dcount()'s... Unless there was an error in the post or I am missing what you meant by this response, but I can see all the Dcount()'s on my screen. I have the form set up as follows: The form that contains the code is...

I have a form that calculates and displays inventory of certain items on hand for each day of the week. The procedure is in a do-while loop that calls a function 24 times (with different criteria sent each time) and assigns the value each time to a different unbound field in that form...

So, I finally figured the whole thing out, for the most part... I got the IIF working, I got the instr() inside the IIF working, and I got the Left() inside the Instr() working. For anybody that is following, what was wrong with the Left() function is that it was returning the correct value...

OK thanks Gemma, that does seem like a more simple idea will try it out, however, I've spent most of the day working on this, and I figured it out to an extent, and just for the sake of learning and so I don't consider my day a waste, I want to figure it out the original way too. I figured out...

So you can actually use the IIF within a dcount??? here's my full code not within the code window, color coded expression, true, false for easier viewing: DCount("*", "[Scheduled Invoices]", [Delivery Day] = "past" _ & "and [Pickup Day] <> 'past'" _ & IIf([Scheduled Invoices]![Size] <>...

I'm trying to create an inventory tracking form (well not exactly, but its best described as that). I'm using a simple dcount function to count records in the Scheduled Invoices query with certain criteria. My problem is, I am trying to use an IIF function in part of the dcount criteria. First...

Ok, I was able to add the field to the query using a dlookup function, but cant exactly get it working correctly. The Dlookup retrieves the correct value, but fills all of the records with the same value of whatever the first value is. I used query design view and entered the following...

I did try that before posting here, but rather, it is not possible in my situation or I just couldn't figure it out. Here's a little more info... The Main Invoices report (and form) is based on the [scheduled invoices] query which is based only on the [invoices] table. The Invoice subreport...

I have a report that is an almost exact replica of an invoice form. The only difference is that the report has an unbound/calculated field that displays a shorter description of the first line/record in the reports subreport (the first item/product listed). i created that field only because I...

OK, Finally figured it out... It was a problem in the syntax. i went through all possibilities and combinations until it worked and the correct (or at least the one that works) is as follows: DoCmd.OpenForm "Invoices", acNormal, , "[TxnID] = '" & Me.[TxnID] & "'" Unless we are...

Sorry for the delays... I had to go take my son sledding!!! (it was fun) So back to this problem. I tried the button suggestion... no avail (opens the form but again all records displayed, no "filter") I tried attaching the code to a field on my report, but same as above. I tried the...

Sorry DCrake I didn't see your post there. I am using Access 2007. The default view is report not preiview, and since I can actually open the form from the report (just not with the criteria specified) I am assuming that a little tweaking would get the criteria working correctly.

I created just a basic invoice form.... Has customer data (name address, delivery address, etc.) in the main form, and has a subform that has order detail (Item, Quantity, price, total, Etc.). The subform is in datasheet view, and main form in form view. If I change the default view of the...

So ultimately I would of liked to have a form in continious form view, but this is not possible in this situation because I have a subform in that original form. (Unless I am worng on learning that it is impossible to have continious form view with a subform in the form.) So as a work around I...

Thanks for the continuing replies! I do already have a credit card validate function in my db, but thanks again for the help. I found one a while ago through google.

Thanks, Well this works, sort of... I put this code in where I am sending the value in the update event and it is sending the leading zero, but I'm still getting an update error. This particular question is officially solved, but now I have to figure out why I am getting the update error. I...

oops, my bad! I didn't realize that the format property was NOT bound to just the dropdown options. I put 00 in the property and now it "displays" correctly, BUT like I stated before, I need the actual value to include the leading zero. Further explination of why: I am using the QOBDC...

I am assuming that you didn't see my last post due to referencing your post times, but I'll repeat. Galiaxomathome: First, I really don't care much about the "display" of the field, but need the actual value of it to be "01, 02, 03..." due to data matching later on in an update query...