Search results

Thanks Drake, is it basically the same for 2003? I should have specified before. Also it's a countof function. Would that be the same for a query, as I think the countof is a result ofa query for the table.

Greetings, Got an issue at work that was discovered, roughly 4 months too late.. yay for me for only one in the office who knows anything about Access. Found this as we were leaving/caluculating last minute monthly stats. So basically here is my issue. We have 2 access databases that gets...

I had a similar problem with our FE and BE on a networked connection. Problem was, after 30 minutes of banging my on desk, was that when I saved the FE it compacted and repaired on close. I could create records on my computer, or any other computer I logged into, however once another person...

alright I'll give that a shot on monday, thanks.

I don't know if I'm out of place here, but there is ALOT of M$ CD-Keys listed in his table. Can't we modify the example, not delete, so others can learn, but no one can take these keys.

Hey all. I got a form for stats tracking. A basic report nonetheless. I have a table called employees, with EmployeeID as the PK and a yes/no for a field with the name "attended" I have a report that has the employee table as the Source, and 2 values at the moment for it to calculate. In the...

Thanks Mr B. I like that approach aswell, never thought of using an after update. I looked at yours and while do so a light bulb clicked my head and I forgot to name the cbo correctly (can't spell ProcedureID), I had PrcedureID. Doh! Just so other can learn as well, here is what I done.

Hi all. I have been tinkering with a Combo box on the main form, and it's selection will dictate what is displayed on the subform. I'm sure you are all aware of what I'm trying to achieve. I have googled for some tutorials, found some examples but didn't work. Anyone have a good example or...

Okay, looked at the relation and the expression, and for my sanity do I have this logic correct? me.counter = Nz(DMax("MyCounter", "CounterTable")("YearVariable", "YearTable" = " & Format( Now(), "yyyy" ))) + 1 So going by what you said above, "MyCounter" and "YearVariable" would be in two...

Great, thanks guys. I'll definately be plugging away at this within the upcoming days. And be posting back. I got about 5-6 pages of a plan of attack written down. The quality office, is very excited that I'm attempting this endeavor to say the least. I told them it is possible and will...

So would it be something like this? And just set the field to "Duplicates Allowed" to "no"? DMax("yyyy") function +1

Good evening. I'm creating a database in which when a new process verification is generated it is given a new record number. (2010-001, 2010-002, etc). My question is, I would like this number to be automatically generated once the user wishes to create a new "process verification". How would...

NVM I got it myself. SELECT Vidmars.CustID, Vidmars.[NatoStock Number] AS [Nato Stock Number], Vidmars.PartNumber AS [Part Number], Vidmars.Description, Vidmars.Location FROM Vidmars WHERE (((Vidmars.[NatoStock Number]) Like "*" & [Forms]![frmAdvancedSearch1]![txtSearch2] & "*")) OR...

I forgot to transfer over the hidden unbound box (txtSearch2)from the "Search Multiple Fields" database example and to copy over the "on change" event code. Private Sub txtSearch_Change() Dim vSearchString As String vSearchString = Me.txtSearch.Text Me.txtSearch2.Value = vSearchString...

Thanks Galaxiom for the reply. I am however, a complete new guy here. And just starting out. I basically, need my hand to be taken and shown how to create such a "query" for instance. I have the ambition to learn how from scratch, but I'm on a dead line by my superior officer. I'm new to code...

I have abandonded all hope of me getting this to work by myself and have came to well, here. I have searched the forums, and have seen many search/filter forms, but I can't seem to get them to work. I have tried http://allenbrowne.com/ser-62.html and just turns into one big fail. Been trying to...

The Customer Control Number is displayed on the form as soon as they enter the first value. (see screenshot) ControlNumber is an auto integer generated by access and is the primary key, no duplicates allowed. I think I got it working almost the way I want it to. Now just have to do the final...

Ya I know it should be "Forms" I was going off the top of my head. Thanks for explaining that, but why would the previous creator have such code? Only reason I can think of is that he wanted the query to use the CustomerControlNumber as his reference when he wanted to view/print a form/report...

I'll give that a shot and see if it will work, sad part is it'll ahve to wait till monday, as I don't have a working printer atm. Also what reason does the ! server in the criteria? I know I want it to use the control number as the means on knowing which table entry to print...

Hi all, as seen by the screen the prompt is looking for the CustomerControlNumber from a table. Now is there a way to have the prompt read "Enter your Customer Control Number" instead of "Form!SupplyData-Input!CustomerControlNumber"