Search results

I always use a external VBA function, of type boolean, for tasks like this. The function can be named IncludeRecord as example and should return True if all the conditions are satisfied. It is slower than SQL but, in my opinion, infinite flexible.

@vbaInet Thank you. After unzip you will see 4 files. One of them is named BE because is the Back End DB. This file can be in any folder and can be renamed without problems The other 3 files are FEs The FEs should be in the same folder. DO NOT rename this files. How is expected to work: By...

Try to open the files then use the Send Key feature in order to command the actions you need (to print - here)

Hello guys, and thank you for yours efforts. The real problem is solved. I reactivated my old desktop computer that run XP and the DB work as I expected. So, in order to learn lets try to understand why the DB don't work on my laptop, under Win7. That, because, in the future, I expect new...

Thank you to all for yours interest. @JHB When I double click the FE s icon, the started form should appear. This should trigger the Open event for the started form and run the code under this event. When I say that "nothing happen" means that NOTHING happen: The started form does not appear...

Open the DB in A2007 then Save As... where you want.

Can t understand

Add a new field (say... IncludeInReport) of type Yes/No to the table (will be a checkbox in the form). Base the report on a query that show only the records that have the checkbox checked. After you create the report you can run an Update query in order to clean all the checkboxes (write No in...

I am sure that this thread is not necessary http://www.access-programmers.co.uk/forums/showthread.php?t=276964 What plog said is to create tables instead the fields with multiple values. So you should create a table tblPanellist and a table tblAttachaments. Then use the PKs from this tables as...

Hy again ! As far as I know, any DB should answer to one or more questions. So, define the need(s) then you will be able to design the DB.

Thank you for the answer CJ. Yes I do. As I said, the DB work fine at the users. Just seems that something wrong happened at the eMail time.

Hy Dick ! Unfortunately... bad news for you :banghead: The routers failed some times but not as frequently as you describe.:p

Put a bit of code in the report Open event: Me.TxtBoxName.Visible = Forms!FormName.CheckBoxNameDo this for each textbox in your report. I think that your report will become ugly because the blank spaces :p

Use "Indexes" at table level in order to not allow duplicates on fields User-Device-Status

Just an idea (I am not sure if you like to use OR or AND in your search): Put the items in a table. Use the previous code in order to automatically filter the list (iterative). At the end clean the table. Hope this help you.

Hello World ! Do you still remember me ? If YES then THANK YOU ! I have a DB: This DB was sent to me via eMail (dropbox). It consist in a BE and 3 FEs. In each of the FEs I have a started form with some code activated by the Open event. The issue: Access do nothing when I open the FEs. Note...

More on this: Try to NOT use an InputBox control. In the main form create a ComboBox or a ListBox from where select the Customer and use this information in order to open the second form. or Use a Form and a Subform.

See post #27 from here: http://bytes.com/topic/access/answers/925508-link-tables-multiple-front-end-databases-same-time Should answer to your question. As Smig said, you should have very good reasons to move the BE.

DCount has it's own query, so no need to design a new one. http://www.techonthenet.com/access/functions/domain/dcount.php

A very useful link: Database Normalization and Table Structures - Microsoft Access / VBA I wish all the best for you ! PS: I don't know the exact expression (in English) for... Happy Christmas . Is someone so kind to teach me this ?? Thank you !