Recent content by naminder

I have a feed file of products from a supplier. I've linked the csv in and am trying to generate a query into my own file to export out and upload. How can I create my own custom columns in the new table I'm creating. E.g. I can filter out the products I want, add a few new columns like...

http://support.microsoft.com/kb/305542/ Thanks, found above link after searching for what you suggested. All about putting it in the shortcut command line to reference the .mdw file for that database.

I am currently developing a security logging in system for databases I support over the network. .mdw files are no good for me as each database is delivered to a desktop, this would require the user to link to a different .mdw each time they used each database. Anyway! Is there any code to set...

My code was ALL wrong. I needed to pass variables to the form. This is my latest code, still working to see if I can put anymore security in. I call the function from the form onload by using Private Sub Form_Load() Call RestrictedArea(Me) End Sub -------------------------------Module...

I have written a module that can be called from a form on open event. It checks for a correct password. I want the code to set different permissions on the form as it opens. The AllowAdditions line returns run time error Public Sub RestrictedArea() Dim strPasswd strPasswd =...

Sorry, was me being stupid. It was working. I just got confused with some test data

Yep, do a screen dump by pressing Print Scrn on the keyboard. Then goto Paint etc and Click Edit > Paste. It should dump screen into a graphic. Crop the image and save as .bmp or similar. Preferably .jpg

In the subform I go to Edit > Delete Record but it is grayed out

Don't think you can as those textures are built into the Word package. They are not "graphics" files as such. That is why you can't select a file as background. You may find otherwise, keep searching

I have a main form where the form record property is set to Allow Deletions: No I then have a subform, but I do not want it to inherit the permissions of the main form. Basically I can't delete on the subform either???

Just to clarify This is in my Control Source property: =Sum([tbl_rooms.size_sqm]) This sums everything fine. I need to save the result in the field from the same textbox: tbl_property_units.size_sqm something like =tbl_property_units.size_sqm And Sum([tbl_rooms.size_sqm])

I have a textbox with it's field control source set. Is there any way of having a Sum function that adds up other textboxes and saves them in this field/textbox. So far i can either set the control source to the field name or have =Sum([size_sqm])

Yep, didn't work just counts all records. I know it's probably a stupid typo, noticed your from my neighbourhood ;) EDIT: found an answer, i needed to Sum and use an IIf to compare, cheers =Sum(IIf([strFKBedContractTypeID]="B",1,0))

Trying to get this to work, on a continous form i have a text box in the footer to count no of records. Want to count all that have a "B" for their value. Why won't this code work in the footer text box source =Count([strFKBedContractTypeID])="B"

yep double click the little black thing in the top left corner of the form to get form properties. then click All tab and find Navigation buttons and change to No. you can also get rid of record selectors etc!