Search results

I have a button that adds pictures/files to a network location. So people from all over the company can do this and all pictures/files are stored in one location. I also have a delete button, but a waning pops up and the file remains on the network. Run-time error '424': object required...

in my report I have table made from 25 fields (5x5) and they all have the Can Grow Option turned on. However the lines and boxes separating the fields do not grow with my fields and I get plenty of intersections and over lapping. Is there a way to make boxes and lines grow with the text box??

I have a report, created in portrait, one of the sub-forms was created in landscape. is there a way to put a landscape report into a portrait report and have it print properly?

I am creating a large report and I have reached the limit of the report page height at 55cm. Is there a way to change this value to 100cm or more. It seems rather silly to put a limit on the size of a report.

I have a query[view] where I have six employee numbers, I left join these to an Employee table to retreive the names. I've created a report that uses this query/view as its source. For some reason my report keeps making all six name fields refer to the same control source Employee.Name and...

For my database, I would like a picture as my background but I don't know if I should use embedded or shared? thoughts?

I am trying to increase a text box field size from 64 characters to 100. I know text fields can hold 255 characters, but whenever I make the change and try to save it, a warning pops up. "Not enough diskspace or memory" Any idea why?

I have a field in my report its name is PreText and its control source is set to a function, =PreTotal() where Private Function PreTotal() Risk = 0 If Me.PreRisk_minor = -1 Then Risk = 1 If Me.PreRisk_mod = -1 Then Risk = 2 If Me.PreRisk_Serious = -1 Then Risk = 4 If...

I have a record set of drawings (DWGNo) and their revisions (REVNo). I want to create a short list that only contains the latest revisions. I tried "recset.Delete" but I believe that deletes the whole record set. Is there a way to delete the current record. Also, does that move lower records up...

is there any way to increase the size of the text field beyond the 255 character limit? I'm creating an incident report and its diffilcult to summarize an accident in less than 255 characters.

I created a text box with a function for the control source =[Location]*2 where [Location] is a field on the same form (right beside this text box). I get this error in the text box #Name? I know this field exists, it's right beside the text box. Funny thing is it worked yesterday. Any...

Using the DoCmd.SendObject is it possible to send an email as a task or of high importance so it's not easily forgotten or lost in one's inbox??? If SendObject can't do it, is there a command that can? thanks

I have a form with a subform. The subform is in datasheet format and is basically a list of employee. So you add as many employees as you want to a particular form (the form is for inspections). Some forms may have 2 employees and others 4-5. I have a button where you click it and it will...

I am looking to see if it is possible to have a pdf viewer in a form. Right now I have the ability to view attached images, but some users may want to attach a pdf file. Also, can the image viewer view the pdf's or do I need to create a new viewer for the pdf files??

I have a database where users can attach documents or pictures to a form. I want them to be able to select the attachment they want to attach to the form from their local HD or wherever and I want it to copy/paste it automatically to a network drive so the database can link to it at all time...

I have form with a subform. The subform displays info in datasheet mode and will have fields, Items and Cost. I want a text box on the main form that displays the summation of all the items' cost. Any ideas? Thanks

I want a combo box to display only current employees, so I have a combo box that displays employees name, with a query WHERE (Status = TRUE) meaning that employee is currently working for the company. Problem with this is, when that employee leaves (Status = FALSE) then all forms that use to...

I have a form titled Vendors and on the form I want a check box/button that has two options "Approved" and "Not Approved". Depending on which box is checked it will only display records (Vendors) that are approved or not approved. If no box is checked then I want all vendors to be viewable...

I have a form that keeps tracks of jobs. On the form there is a combo box for customer numbers. Beside the combo box there is a list box that displays the name(s) of the customer with that number. The query attached to the list box works fine, whenever I change the value in the combo box it...

I am trying to create a switchboard using access 2010 Switchboard manager. When ever I try to link a switch board item I get teh following error. 'FillLstArg' may not be a valid setting for the RowSourceType property, or there was a compile error in the function. I don't know what a...