Search results

Does anyone know of a setting that would make the "analyze with excel" button on one users machine to be greyed out and unclickable, when it is fine for other users? Is it a permission setting? Maybe something missing from the install? Any and all help appreciated. Regards.

A copy of a small database that serves as a timesheet for each member of staff in my department did something bizarre today. :confused: :confused: Each member of staff has a local copy of it in their personal space, and they all update a central copy when they are exited. This morning one...

Hey All, I've had a search for the last hour, but I haven't found anything for this topic. :confused: I have a query def (qdf) setup for query1 I want to change the criteria part of qdf.fields(0) from: =date() -1 to =date() - x : x will change in the code. I was hoping for something...

Hey guys Looked around for a solution to this one, but can't find one. On a form we have a button that when pressed opens another form, fills in values on the new form. Now we want to press that forms 'OK' button but as it isn't a sub of the original we are struggling to find the right syntax...

As part of the system I'm building I use the pop-up property for all forms. As I close one particular form I want it to 'click' a button on the form beneath it. I've pressed a button with another button before with : buttonName_click and I've accessed data from another form with ...

Hey Not sure if this one is possible. I've looked around the forums and the internet, but I can't come up with a search string specific enough to help. I would like to open up a windows folder so the user can view it. For example C:\Example\New Folder. I also would like to open a .pdf file...

Hey Everybody I have imported tables from a foxpro database (as readers of my other problems will be well aware). Part of the problem with the imported data is the jobno field. The jobno is either 4 digits - like a pin number. i.e. 5678 etc. or is 4 digits "-" 2 digits to indicate a subjob...

Sorry for all the questions today guys. I do try and find answers with search, but I rarely know what to search for. On a continuous form, how do a move through the records. Thanks

Strange problem - but I'm sure it's possible I want to click a button, and doing so, cause the OnClick event on another button to run. The reason for this is eventually I want to be able to click one button that effectively runs the code for a dozen buttons. Thanks in advance

Hey Part of the system I'm writing involves importing timesheets from Excel spreadsheets. I have the importing sorted thanks to some help in other threads. ;) However, the importing is done 1 spreadsheet at a time, specified by the user. What I need to do before that is check the integrity...

Hey all I keep getting this error :- on this line :- If xlSheet.Cells(DataEnd + 1, 3) = "" Then I have several lines of code like the one above in the module and the program seems to randomly pick which one causes the error on each run. Any help much appreciated. Thanks

Hey guys. I've searched around a bit on this one, but I'm not finding what I need. Staff here used to fill out timesheet information on a sheet of paper, hand it to an admin staff member and she then typed it into a Foxpro database. Recently, with progress being made on my Access system that...

Hey guys I have a query that is fed a year period number (eg 200303) by the user and works from that. This query is then tied to a form and the form displays the results. Is there away to also put the year period entered into the query on the form so I can use it later. i.e query requests yr...

Hi again. I've been using this line to link to recordsets :- set rs = db.OpenRecordset("Rates") So far it has worked fine, but they've all been tables. I now need to do the same but with a query. Set rs = db.OpenRecordset("Rates Query") This query selects records depending on 2 values...

Hi Guys :confused: Is it possible to change a forms record source from within an event procedure? i.e Form Rates record source is currently Table [x] and I need to change it to Query [y]. I will then need to set which field each of the text boxes uses in the new record source. Basically I...

Hey everyone, :D I have 2 tables. The 1st table stores details of invoices sent out to clients for paying. The 2nd table stores details of projected invoices, and when to send them out. What I want to do is allow projected invoices (2nd table) to be "promoted" to actual invoices (in the...

Greetings. In a table I have a column filled with 4 digit numbers. I need to convert these number to 6 digit numbers. The conversion I have worked out. However, the column properties only allow 4 digits. To make it 6, I have to physically go in to the design view and change. As the data in...

I've tried looking for a solution to this one, but just can't find anything with what I'm searching under. I have a form with 2 boxes empty, awaiting user input. The first box specifies which excel workbook to open, and the second box specifies which worksheet to goto once it has been opened...

Front End Screen My first post, and its a general "Can Access do this" question. My boss, for the benefit of less computer literate employees, wants the Access system I'm working on to display a front end screen that is outside of the main Access window. That is, when opening the database...