Search results for query: *

I have this Form that has a Subform. This Subform is about 75% the area and has only 1 object: a picture. Let's say I change the picture with a bigger one (bigger than the subform's area). Obviously scroll bars appear. By moving the scroll bars I can reach the both ends of my (bigger) image...

I know that a subform on a main form is not a form, but is a control just like a text box etc. and the proper way to refer to it, is Forms![MyMainForm]![MySubform].Form![SomeID] To my surprise I can't get this to work, as "criteria" in a SQL query (I have a report taking data from that...

I have a db split in FE and a BE. I already have implemented a piece of code for relinking the 2 ends (with a select folder dialog) in case of the BE has moved. How can I get (through VBA) the OLD PATH of my back end? I mean if the BE was in "c:\dbold" and I move it to another location, how...

Hi I have this "finished" db. I prevent the use of shift and convert it to acdde. I Know that there is no viewable VBA code after the acdde conversion and you can't reach the VBA editor because of the disabled shift. Nevertheless I put a password for my VBA code (so if there is another way to...

Hi I am a newbie in JavaScript. I am trying to change the useragent string of my browser by using a Greasemonkey script. So far I have done something like that: GM_xmlhttpRequest({ method: 'GET', url: window.location.href, headers: { 'User-Agent': 'Mozilla/4.0 (compatible)...

Yes, I know the argument "print a report, forms are not suitable for printing etc.) I was using a button (with the predefined macro for printing)to print a form. The result was satisfactory, but I have a question. How an I do this with VBA? (I imagine is somethink like DoCmd....) and MOST...

This is the first time I'm trying to release a db to other users. I am not sure about how secure is my db, maybe this is the topic of another thread. Anyway... I tried for the 1st time to use PSW and I have some observations/questions that you may help me with. (1) As I saw PSW can't install...

[Access 2007] Hi guys. Is there a method to split a db to FE and BE, but the BE to have only some of the tables (for example 10 out of 15) and the rest (5) to exist as linked tables to FE? and a 2nd question: Is there a way to re-merge a split database (to its previous state with the tables...

Hi guys, I m trying a simple script for greasemonkey/firefox and I have some problem with & (ampersand) var links = document.links; for (var i = 0; i < links.length; i++) { var link = links[i]; var linkString = link.toString(); var indexOff = linkString.indexOf('&'); if...

Let's say we have a table with people data, primary key PEOPLEID. We make another table (I dont want to use the term group) TEAMS. Every person in the people data table could belong to a TEAM or more than one or all or none. My first problem is how can I deal with this in tables/fields level? I...

[access 2007] Is there a way to prevent the user from putting the cursor inside the text part of a combo box? I tried some properties (locked, enabled) combinations but It didn't work as expected. If you have the enable=no then you can't click the box's arrow. If it is locked you can't select a...

I have this idea. It's not obligatory to my form but if i find a simple way to do it, i maybe implement it. Let's say we have a report that serves as a list of records. I want to be able to click on a line of my report and jump to the main form with the full record. I think the crucial step is...

I have this routine for custum dialog box that works fine ONLY when I "remarked" everything after the Response = acDataErrContinue in the if statement. I am just trying to have a "Record Deleted" dialog and close the form and open my search form. If I enable the 3 lines (or just the 2...

Is it possible to have a control like this in a form in Access2007? Instead of a listbox or a combobox. (I am referring to the RIGHT image "Properties menu", NOT the calendar control) I found it in this page http://www.lebans.com/monthcalendar.htm BUT unfortunately I can't open the sample...

Hi guys. If you have a form that has the property "pop up" ON and there is a combobox in that form, that you can edit its list by pressing the *ghost pencil* at the bottom of the list, a weird BUG happens: If you press the pencil button, the edit list dialog opens, but (especially if you...

Hi Guys. I have already made some custom dialog boxes when you delete records with Private Sub Form_BeforeDelConfirm(Cancel As Integer, _ Response As Integer) ... However I can't find how can you display custom dialog boxes and to avoid the access's dialogs when you run a delete query...

I have a form (data from table1) and a subform (data from table2) in it. The tables have a one-to-many relationship. To my surprise, MS Access lets you enter data into a sub-form before the master record is created. So I searched and I found that the proper "solution" to my problem is to check...

Hi guys! I have an index form (that you search your record with a FAYT listbox) and I have a "New record" button in it. My code for the click event is DoCmd.OpenForm FormName:="MyForm" DoCmd.GoToRecord , , acNewRec It works (it opens My Form, and it ir ready to receive data) BUT for a...

Hi guys ans a HAPPY NEW YEAR!!! How can I have the header of a report (on screen) to stay still (at the top) as I scroll the body of the report? I think I have found a property that works for a continuous form but I can't find any for reports...

Hi guys, Happy holidays to you all !!! I have finished my db (a project I started a few months ago) and I am very happy with it! A few people I showed it, were very impressed by it's design and functionality and I am now thinking of selling it to the public (here in my country at least). It's...