Search results

but thats my problem bob, the tables are linked, when the backend is moved, it cant check the table for the value.. I just realised I got this code from this site.. Its the code that relinks the backend tables. In the code, it does a check on the backend location and if needed, prompts a...

Ok, I think i know whats happening It seems that the code correctly assigns the updated location to the form, but when the form closes that information is lost.. I've tried using docmd.save acForm, frmLocator but that gives an error saying i cant use that function at this time.. odd Any help...

so the Detail space is empty when your on Form View, but Design View shows there being objects.. most odd... Are the controls set to Display When = Always?

check to see if its simply minimised inbetween the header and footer.. put your mouse at the join between the two, click and drag down.. that may reveal it.. the other thing you could do is simply copy all the controls and code to a new form

Ok, this may be really stupid and easy but it has me baffled.. I have a form that i use to store the location of my be.. on startup, it checks that forms control, then does its bit and if need be selects and loads the correct be.. for some reason i cannot get the code to reset the control to...

Ok, after some digging I have found that somehow the mainforms subform had changed sourceobject. I have a statement on the first line of the mainforms load code which changes the sourceobject to the correct form however this does not fix the problem. Is it possible to change a forms subform...

more information is needed. but you shouldnt be doing that

well i would think that when you create a button, group a lable with it.. create a button, create a lable, select both, go to Format and group as to making the text change, could you simply put in the Mouse Down event a change of font weight to bold or something...

yeah, i found this to be a bug with lables.. one way to fix it is convert the lables to text boxes. disable them and change the background color to make them look like lables.

dont know if it would work, but you could put the maximize code in the Got Focus event on your switchboard

Hi, I've posted this before but i'm still having problems. Every now and then when i open my main form, the load function from other forms fire off, which gives random errors since certain parameters havent been calculated yet. Has anyone had this happen to them.. The code of my main form has...

http://www.access-programmers.co.uk/forums/showthread.php?t=150015&highlight=recordsets this link might prove useful for a bit of background on recordsets also, i'm not entirely sure how you want to setup your form, but you could simply set the record source of your form to the SQL statement...

with your query, copy the SQL and do it manually in the code, and simply pass in the student name to the end of the query. i.e. stringtxt = "SELECT * FROM wherever WHERE studentname = "& txtbox you could then load that into a recordset and populate a bunch of fields on your form that

Ok so I have this setup now, but unfortunately I fail to see how this solves my problem. To my untrained eye, it seems that this produces the opposite of what I want. When I open the Approver table, there are the 2 fields approverID and approverName, and a little plus sign on the left that...

ah yes.... thats EXACTLY how i had it :o lol

this may be a stupid question, but should the relationships be defined in the front or back end of my database? also, what field do i select for the second line of the index. For example, in your above table list, for tblApproval, when creating the index for approvalID, what would the two...

I dont understand what you mean by this

Ok Neil, I think im starting to understand this. This seems a little more complicated than the previous things i've been doing so this is approaching new ground for me and I thus may need to be led by the hand a little. Once I setup the table structure like this, how do I populate it so that I...

basically the system is for tracking changes. In order for a change to proceed it must be approved. I have my system correctly identify who the approvers are. there are usually 3 approvers. After a change has been initially submitted it goes into a standby while it waits for all the...

Hi, I have an approval system im building for my database, what i want to beable to do is have a list of people that have the right to approve somehow be stored in a table.. this list would probably be their userID. My problem is I do not know how to store something like this.. Approval...