Search results

I have a table that contains a lot of unnormalised data. The table contains two columns those being 'PKG_CODE' which is an alphanumeric two character code and 'PKG_DETAILS' that contains a list of publications that make up a package code i.e. LE+FT+FB+FD+FE'. I need to develop an application or...

Hello Mile!!! I was wondering how you built up your vast knowledge of Access and if you could give any pointers on how to improve ones knowledge of the application??

Cheers, superb!

I tried your solution The initial field was: SumOfSIZETY And after changing it the field was SumOfSIZETY: Vol When executed this prompted me for an input??? I just want it to replace SumOfSIZETY with Vol?? Any ideas? Thanks

Hello, is it possible to rename a field by using an expression. I am attempting to produce a make table query and instead of using the default column names SUMOfCharge and SUMOfVolume I would like to rename the fields Rev and Vol. Does anyone know the syntax? Thanks

How do I go about completing the first activity, after obviously creating the table??????

I have tried opening the file in both Access 2000 and 97 and neither will recognise nor open the database?

Hello guys. Is there any way that you are able to create a log or a journal of the success or failure of activities performed within a database. I want to keep a log of the time a button was clicked on a form, whether the underlying queries, macros, modules and reports ran ok or failed and if...

I was recently working on an MS Access database. However last night I closed the database down as normal and now the database will not open up. When I try to open the database I receive an error message that reads "Unrecognised database format c:\mydb\changecontrol.mdb" When I look at the file...

So is there anyway to simply find out what indexes if any exist on the database?

I have created many modules by writing a macro and then converting it into VB using the convert function within Access to accomodate some features the Macro is unable to perform or calculate. After comverting the macros can I then delete these macros to free up space in the database? Or do they...

No, no graphics. There are six forms that are no longer in use. What typically takes up most space in a database? Apart from the obvious huge tables, etc? Thanks

Sorry, but it is still really big in size after the compact

Hello, thanks for the prompt reply. I have compacted the database and this reduced the size of the DB in MB.

Hello guys. Does anyone know how to check how many indexes have been created on a table? I am attempting to discover why a database is so big in size and think this may be contributing to it. Thanks

Cheers that worked a treat! Another valuable lesson learnt. Many thanks

So typically I would specify in the qbe: Between "L300" AND "L499" or Between "P300" AND "P499" or Between "S300" AND "S499" or Between "W300" AND "W499" Thanks, sorry I am a rather inexperienced but keen Acces user

Thanks. If I were to copy and paster the syntax you provided me with do I need to enter the name of my field Per_Source_Sent into the [] parentheses or can I cut them out and will the query pick up from the field the syntax has been entered? e.g ((([Per_Source_Sentine]) Between L300 AND L499) OR...

I am attempting to build a query based on a selection/range of data. The values I wish to search for are >=L300 AND <=L499, >=P300 AND <=P499, >=S300 AND <=S499, >=W300 AND <=W499. How would I construct the criteria to include all of the data? Thanks

I dont mean to be a skin flint but is there no other free way? I do not think my boss will sanction money for the repair and will look to a back up, which I am reluctant to do. Are there any other free utilties or other ways in which I can attempt to recover the database? Thanks