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...

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...

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 =...

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???

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])

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"

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...

I want to replace the standard update record message with a custom one. My Code strSQL = "UPDATE tblBeds SET lngFKStatusNo = 2 WHERE autBedNo = " & Me.txtFKBedNo & ";" DoCmd.RunSQL strSQL You are about to update 1 row(s) Want to replace this with a msgbox saying "Are you sure you want to...

:eek: I can't seem to find one that will do what i want. I have a tabbed interface. Tab one has details about that record e.g. clients Tab two is an input form that lets you add new client Basically after i added the client i want to go back to view this record in the first tab. i can put a...

I am wanting a text field in a table to accept only chars A - Z In my validation rule I use Like "a" Or "b" Or "c" Or "d" Or "e" Or "f" Or "g" Or "h" Or "i" Or "j" Or "k" Or "l" Or "m" Or "n" Or "o" Or "p" Or "q" Or "r" Or "s" Or "t" Or "u" Or "v" Or "w" Or "x" Or "y" Or "z" Which works :D...

Hi I have a problem where the user has certain contraints in colour. I am trying to change all the colours of labels in the database to purple. Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also...

I am trying to display two fields when the combo box is unselected. Basically I have a table source manufacturer. This table has Manufacurer e.g. Nokia. Model No e.g. 3230. So on the combo box i want it to show Nokia 3230. Saves me linking to a subform to show the information. Can it be done???:)

Hi I have finally finished the database but i have a major report I am having trouble with. I need a report that works in stages for a property building system At the top is the property type this has a table property materials showing the materials it is made of, costing Then property...

Hi I have read through this forum and found some help on this but can't get it working. I have a subform Activity Contains a tab control with two tabs Activity Details - Persons I want to copy the address field from Activity Details tab to the Address field on persons tab Code for the on...

I need to select two fields in a select DISTINCT query Select tbl_Aplaws.AplawID, DISTINCT tbl_Aplaws.Level2 FROM tbl_Aplaws WHERE tbl_Aplaws.Level1 = 'Business' ORDER BY tbl_Aplaws.Level2; anyone know how to make this work?

Hi I am trying to use a query to populate a combo box. works fine as I am using one table. I want to select DISTINCT records which works. However i need the ID of that record in the select statement. Anyone know how to select two things in a select distinct query?? Select DISTINCT...

Hi, I am trying to find code that will let me put a command button on a search form. When it is clicked I want the command filter by selection to filter the records. Basically copying the command when you click the button on the toolbar :rolleyes: