Search results

Looks like it is, just I have no clue how to implement this...

Hi all! Can someone guide me how to implement this? Where to put this code and how to get it run... THNX

So, I need to make sure that there is NO SECURITY WARNING message when opening my database in Access 2007, because I have some procedures than will not function otherwise. I googled it but I was only able to find VBA code for Excel 2007. Any clue here?

Actually, this does the work! THNX :D

Is there a way to save temporally value of combobox? I have form set on data entry and combobox with value of another table. Every time I go to next new record combobox value is reset to default one. I'd like it to stay on previous one...

I've been struggling with this, but no luck... This what you suggest works, but only when opening form and it does not change after. I’m trying to have user enter data (customer’s names) in to certain shelf name so that after it can be retrieved. But… often user has lot of different...

I have one unusual problem to solve… There are a lot of PDF files (over 160) with unique name (Spec_385912347657_200909) that are actually phone bills that need to emailed to a customer in database. I need access to disregard first 5 and last 7 characters, do the check within the database, and...

So, After long time not using this the way I want it, I managed to get it right! This is what I used: I created unbound textbox in main form and entered: =IIf(IsError([Isporuka2 subform].[Form]![totalsub]),0,[Isporuka2 subform].[Form]![totalsub]) As a result when there are NO records...

So, I have form with fields of table for new entry and subform table that is showing all of records (Master - child fields links are empty) and that works fine. Now I'd like to make search button that can search ALL the fields in table and show them in subform table. Any ideas?

Hi all! I have form based on one table with data to be entered and I'd like to include sum of data of a query. It is basically sum of money obligated in a query that I'd like to be shown on a form where you can enter new data. The problem is if I create a query (SELECT type) with all of the...

I have form that is set to DATA ENTRY on (name of a customer) and list box of shelves names based on a table and this is what happens: When a shelf is selected and customer is entered (trough combo box) the value of shelf is set to default (none selected). So I'd like to have shelf name in...

So the code is very simple: =Sum([kom]) - kom is equivalent to each (item) And as for one unbound textbox shows (calls) another in subform - well this is the only way you can actually see values on main form from subform. The error appears in situation when there are NONE of the...

Hi! I get an error when summarize a field in datasheet when no record is showed. Let me clarify: I have main form with datasheet subform in which I have unbound textbox that calls another unbound textbox in subform (this one summarizes how many items one customer has) So you can search...

WOW! This looks damn good! I didn't know you can actually do it like that Thanx

New upload on post #7

OK, this is only beginning of database

Now I'm lost...

OK? How to do it... I understand for customers but how to present them TOGETHER in purchases table...

Hello all! I have some problem with two fields in one table (first name and last name) and same two fields in another table... I'd like to select last name from the main table (purchases) from drop down menu and to have first name in the field next to it to be filled also.... Of course last &...

OK! How? Do not know syntax at all...