Search results

Cheers guys, managed to get it working by importing the table then copying it to a new table with a text field instead. just need to automate it rather than do it by hand

I have linked a "table" from AS400 via ODBC, however when I view the table in Access one field with a list of numbers develops a small issue numbers such as 3880470 are fine however 4242002557649 appears as 02557649E+12 how do I resolve this, NB: Using Access 97 on XP Machines ( I...

Cheers Guys

Having an issue with an unmatched query, The first part retrieves a list of people who have passed a course and compares it against another query to check that the course has not expired, this is then presented to the end users, however when the query is run it reports This recordset is...

Found the issue, I had set the field as an Interger, Also bob tried to use Dim mp As Decimal Is not available on my version access, not sure if its the version or the setup All solved, cheers guys

The Text boz on the form is set as Fixed 2 decimal places

Hi All I have an issue with this piece of code This code converts fuel in litres and Kilometres covered in to MPG However when it writes the answer to the field it is populating the answer is being rounded, field is set as fixed to 2 decimal places. I am using Access 97 (yep still in the...

Hi All Currently got a sumif formula that works =SUM(IF(Sheet3!$A$2:$A$1059=D15,IF(Sheet3!$D$2:$D$1059=D16,IF(Sheet3!$E$2:$E$1059=D17,IF(Sheet3!$F$2:$F$1059=D18,IF(Sheet3!$H$2:$H$1059=D19,Sheet3!$L$2:$L$1059,0),0))))) Where D15,D16 etc are drop downs that allow me to filter the result...

David, Read the earlier posts, these are shared files on a network drive, Have to remove it as it was falling over if I did'nt 3.5 and 3.6 have the same reference name and both are available on the build, In tests, users logging in from both OS's at the same time have not had any...

Hi David You are quite right I did forget close and release the variables, my bag, RE: The problem is that both DLL's are present on all machines as part of the standard build, however if 3.51 is referenced in the database which is opened in XP, it falls over, same happens with 3.6 and...

Hi Guys Here is the solution I have ended up with, it seems to work, and the intention is to add it to each database, I ended up looking at the Windows directory to establish which OS was installed (2000 or XP) as OS was reporting WinNT for both, however our standard build is producing...

Thanks datAdrenaline, Will give that a try, ChrisO, not had any problems with sub reports that i can see but will keep my eyes open. Will keep you posted Thanks Hawk

I fully agree with you about the FE/BE issue however, I work for a contactor working for a multinational, who’s IT is handled by their Parent company, The heavier used Databases do frequently fall over with corruption, we then blame them, they say “ok, can you fix it or do we need to restore the...

Thanks will have a look at “Late Binding VBA” and Re Unfortunately yes, not an ideal situation but we have numerous users updating the data, and as I mentioned the split FB/BE system just does not work with our set up, tried it once and all the users got access denied when they tried...

Hi Guys I need a way for any database that opens to Load one of two reference library’s depending on the Operating System version For various reasons we are forced to run Access 97 across all machines onsite, however due to recent hardware upgrades we have some machines running Windows 2000...

Hi Guys Does anyone know if it is possiable to caputre and store what a user inputs into a search box. I have a button that focuses on a field and then opens the search dialog, but I could do with being able to capture the information they are looking for. Me.fieldname.SetFocus...

Hi all, One of the databases we use on site has disabled all the menubars when I open access I have tried to use the shift override however this does not resolve the issue I have also tried Application.CommandBars("menu bar").Enabled = True This works while the database is open but the...

Does not appear to be related to that, printers are all set to A4. First print of the page can be fine Second copy 30-40 seconds will sometimes just print "IB" in top left hand corner

We are encountering intermittent problems printing out certain reports on one of our databases. The issue is that occasionally when printing we get just the one sheet with IB in the top corner instead of the report we have pressed print for. We have noticed that this is more likely to...

Cheers Guys