Search results

Hi Folks Hopefully a nice easy question for all you pro's :) Is there a simple way of increasing the size of the yes/no box on a form

Hi I am running an update query to update 2 fields in a table, field 1 is an average of 2 of the other fields in table and the 2nd field is to update the week number number field. This seems to working ok, but I would like week 1 to begin on monday 27th February 2012 not on the 1st january...

Hi folks I am trying to import multiple csv files into a temp table, here is the code i am using Private Sub ImportMultiple() Dim strFile As String Dim strFileList() As String Dim intFile As Integer Dim filename As String Dim path As String Dim Response As String Dim myStrFilter As String...

I have recently been assigned a project from my work and I am looking for some opinions on the best way to setup a new database. I am not completely new to using access and have created several system that are used in my company on daily basis. New project outline: At present we receive an...

Hi I am trying to save a report to pdf for the current record but cant seem to manage this. I remove the "POID = " & Me.POID, it will save to the correct place but it is not the information on the report for the correct record Does anyone know what is wroing with the following code Private...

My access program crashed the other day now when designing my form when i click on view code a box appears with the heading MICROSOFT VISUAL BASIC and in the middle FILE NOT FOUND, with an ok button and a help button. Does anyone have any idea why this is happening. Also any new command...

Hi I am currently trying to get a query to work where I want it to be able to look at 2 field and display the results. My Table has the fields Completed and FurtherAction, Both are tick boxes I want the query to be able to show all work which is incomplete hence completed will = no and...

Hi there Please excuse me i am a novice at access. I am getting a runtime error '2110' - access can't move the focus to the control ProductID What i am trying to do is when a query is ran from the products form it displays another form with all possible matching records (this works ok), but...

Hi i am trying to make my database look a little better, at first i had all me forms formatted to the stone effect, but now am trying to set them to the standard one. The autoformat works ok of most of the forms, but if a form contains a subforms it will format the main form but not the...

Hi i have recently created a purchase order database and it runs great until i came to doing a report. the report lists Qty, Description, Unit Price, Total Price. The total is qty* unit price and this displays ok using =[Unit Price]*[Quantity] but when i try to total the total prices in...

Hi guys I have created a button on one of my forms to open another form, but when it is pressed is displays all the records associated with it , can i set it so it opens on a blank record only ready for inputing txt. Cheers

I have a form, with customer names address etc, with also shows a subform of work done for this customer, the sub form is in data sheet view so all previous jobs appear like a list. However i now need to add a report onto certain jobs, i know i can link a command button to a new form in form...

I am a complete novice at access and would appreciate any help i could get. I have attached samples of the files i am working on, there are 2 tables and 1 form, what i am trying to do is auto fill fields based on the info from the risk types table into the risk assessment form, however after...

Hi there i have been using this forum and have found it very useful, thanks to all who contribute here. My latest problem i am facing is i was wondering is there was a way that if and option is selected from field1 which is a list box can the next field be automatically updated with txt to...