Search results

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!

This is the exact setup we have got. We run a city wide network and have our databases on a network server. For our users we deploy a runtime version. basically an icon is delivered to the users desktop and they can view the database. Runtime gives you access to the forms only. Users do not...

is the Id an autonumber field or unique to the customer? you could try by finding what is unique. then run a query before they enter that counts how many entries they have If ID > 3 And Date Between "Lirst" Date and "Last" Date Then Msgbox

I have tried and searched as much as i can. I have a continous subform, a text box which has a date. For each row i want a button to be visible where the date is blank. If the date is filled in No button. So i thought need an event. But where? Can you reference row values? Here's the code...

ok noted! It's just that Access 2003 puts it in by default. I created a simple save button originally!

Great thank you, that worked! Can do custom messages now! though i would post the code for others ;) In the onclick event of button Dim LResponse As Integer LResponse = MsgBox("Do you wish to Confirm Bed?", vbYesNo, "Confirm Bed") If LResponse = vbYes Then DoCmd.DoMenuItem...