Search results

Thanks a lot, I will take a look this afternoon :o

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

Decided to take a different approach to this using a week beginning field instead of week number, this way it eliminates having to change when the week numbers begin. Thanks again for the help

Hi still fairly new to access and best practices etc, so can only work with the limited knowledge I have i am afraid :( But the end result of this is sum calculatations of the averages from the weeknumber field see attachements for final query and results it produces

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

Yep I have no way of changing the format of the filename before it is sent it is automatically generated. We are going to be getting sent about 40 of these files everyweek so was hoping that i wouldnt have to rename them. Is there no way around it? thanks

Seems to be problem with the filenames, if I rename files first it seems to work ok :( Sample of filename: S019 Shrewsbury to 10-02-2012 12.24.59 (15min).csv Do you know if this should be a problem or if there is anyway around this?

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

Thanks guys information greatly appreciated The fields are set during the setup of the individual store and the program that sends them cannot be adjusted, everything seems to be preset, at the very most there will be 14 columns in one of the csv files. I have attached another file showing...

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

Its ok got it sorted just had to do a bit more searching

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

Yep that is correct

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 thanks for the help you were correct, productid wasn't enabled. works great now Thanks again for your help Mark

Thanks for the replys you see I have used this code before on another database i have done and it works great, i just cant understand why i am getting the runtime error with this one, as i can see no differences between them. What is this set focus thing?? been at it all day..eyes going...

yep can see the first form is still open after results are displayed on new form

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