Lewe22
Last Activity: Sep 10 '08, 11:59 AM
Joined: Sep 11 '07
Location:
-
I'm not sure, how do i find this out? -
Hi. I just looked into that but there are no references missing....Leave a comment:
-
Data Type Conversion
why would i be seeing a 'Data type conversion' error when saving records to a table on 1 machine, but when saving the exact same record from a number of different machines it works fine. All machines are running the same version of the database, saving to the same table etc etc.
I'm absolutely stumped. -
Thanks for everyone's help. Really appreciate how quickly you all came back to me!
I have resolved my problem using hjozinovic's suggestion (below)In my particular...Code:If FrontEnd is developed on your PC and distributed to other users you should make sure the tables are linked correctly to the database because the path to the database is now changed for them. Make sure they run Linked Table Manager and refresh the link to the database.
Leave a comment:
-
Yes. It happens when logged on as SuperUser or CallManagement. I'm just not really aware of what else it may be as i have ruled out the network access.
It may be worth noting that this error is occurring when trying to access any table info from a form (eg: when selecting the drop down for a combo box which looks up from a table) and not when initially logging in.Leave a comment:
-
Hi Neo, yes. It's very strange. I'm at a loss as to why this is happening. All other machines i have tried this on are experiencing the same problems. It's not about access to the back end on the server as everyone has full permissions to the folder...Leave a comment:
-
Disk or Network Error.
I have created a secured access database which contains the following....
On Server: Back End
On Client PC: Front End, Workgroup and Shortcut (to point user through workgroup)
The workgroup i have created contains two log ins: SuperUser - (With privileges to create and edit all objects) and CallManagement - (With restricted user access).
When logged on as the SuperUser from my machine i have full access... -
My new workgroup had become the default. To fix this i rejoined the default access workgroup System.mdw, found (in my instance) at:
I then created a shortcut which would direct the user through my desired workgroup for each access sesion.Code:D:\Documents and Settings\LEWAL02\Application Data\Microsoft\Access.
Something like......Code:"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\My Documents\Call Management
Leave a comment:
-
Why does that prompt for a password?
I have other databases previously created that are now asking for passwords.Leave a comment:
-
Security/Workgroup
Once i have created a workgroup file to secure my database and prompted access to ask for a password it is asking me for a password every time i try yo open any other access database. I only want to be prompted for the password for the secure database, what have i done wrong? -
Find Previous Monday
I need to create a formula which works out the date of the previous monday.
I have an entry form which is accepting amongst others a date from a user. I then want it to check to see if an entry has been made in the same working week and if so display a message accordingly.
Can anyone help me with the formula? -
Validation
I am trying to set the validation of a text box and have run into difficulties.
I have a main form [frmDistLearnByS ubMain] which contains student, assessor and course information, and a linked subform [frmDistLearnCon tactDets] which contains expanded details of all assessments made by the assessor. (Shown as a continuous form)
The sub form captures amongst others the start and end time of the assessments. I have a field... -
Discovered that HasData can only be used for Reports.
I fixed this by creating and then calling the function suggested here:
http://www.mvps.org/access/forms/frm0022.htm...Leave a comment:
-
A little more information...
My text box is pulling data through from a sub report and currently has the following code in its control source:
(subreport name is in bold italic)
I am receiving the #Error when the sub report contains no data.Code:=[Forms]![frmDistLearnByStudMain]![[B][I]frmDistLearnByStudCalculatePrevSessTotalHours[/I][/B]]![txtDuration]
I have done some research and have discovered that i need to incorporate...Leave a comment:
-
Remove "#Error" from form control
I am wondering if anyone knows a way of representing a "#Error" shown on a form in a text box as 0?
I realise this is not the most logical thing to do but does anyone know if it's possible. Perhaps using an if statement? -
Thanks again for your time everyone. I'm just glad it's working now and i can move on!Leave a comment:
-
I don't really know what was happening here, but i will explain what i did to resolve it.
I had created a series of queries, lets call them query1, query2 and query3.
Each query was perfoming its own task and was then referenced in the next query in sequence. (Eg, query1 was called as a table into query2 etc. etc.
I had linked a table named [tblStudent] into query1. This was showing [title], [forename] and [surname]....Leave a comment:
-
Not really sure what you mean by summation formulae. What is that and where can i copy it from?
Also, even if i take the sum out but keep the grouping the same thing is happening...Leave a comment:
-
Loss of data in query field when selecting the totals
I have a basic query [qryGenerateFaci lPaymentsStep3] which is selecting all information from another query [qryGenerateFaci lPaymentsStep2]. As soon as i set the query to show the totals (in order to perform a sum) all information held in a field named [forenames] is replaced with strage characters like "ᘈ" or "ᘈ".
When removing the totals the forenames are all shown normally again.
I have checked... -
My apologies, it did work!Leave a comment:
No activity results to display
Leave a comment: