Search results

Hi All, I have three databases; Frontend, Backend, Snapshot. I want to be able to have a feature in a form in the frontend database where I can delete a table which I select from the Snapshot database. Any idea how to do this? I have the following code I need to change the copy...

I tried this doesnt work thoguh and overly complicated

almost perfect problem is its only one of the fields im interested in which is the provisional one all others could say "Chargeable" but this one could be blank or something I want it so if that particular record is "Chargeable" then disable/enable buttons. Thanks for the try though...

Hi guys I've got a form with a subform, which has 4 records below: ID - sStatus - sAvailableStatus 1 - Holiday - Unavailable 2 - Unavailable - Unavailable 3 - Confirmed - Chargeable 4 - Provisional - Chargeable Then in the main form there are two buttons cmdExcludeProvisional runs a...

thanks very much it works

Hi guys, I have a table which has several fields but im focusing on job names [sJobName]. Example: sJobName Jobone Jobtwo Jobthree ZZ_Jobfour ZZ_Jobfive I want to somehow filter out any records which have a job name starting with ZZ_ How would I acheive this? I have tried using...

cheers that would have worked but when i made it for all 24 rules, the expression was too complex and it didnt allow me to use it you did help me out with it massively though by the dots error! i realised the first formula i ever tried, replacing [ ] with dots worked...simple as a pimple...

Hey, Thanks for the reply. Interesting analysis there. The table isnt used as a display for end users but mainly for functionality purposes in the backend of the db so this table wont actually be viewed by the end user. The purpose is to change all employee grades into shortened codes...

I wont need it for any of the grades which correspond with "Other" so that would cut it down by a few. However if someone started it off and got it working for a few of the grades, i could carry on the formula if you know what i mean unless its really complicated lol

ive tried so many revisions of this formula and all of them miss out creating the other records... please could some one open the attachment and do the correct coding on the query? this would be much appreciated even only for the 3/4 grades ive listed so far and i can work on the rest

Really good idea with the combo box thing but unfortunately this database is being imported from another program which doesnt have any real validation and is being used across europe hence all the deviation in naming conventions! It looks like I will need the lengthy formula i've tried doing...

The above is the SQL view of the query if you use the IIF function

ive already tried the IIF function. the code would be as follows: But the problem is when you run the maketable query, only the records which satsify the requirements are copied over and the records which have grades which should be classified as "other" are completely omitted. thanks for...

Hi i have removed lots of stuff and uploaded my database just showing the two employee tables and the grade filter table. if you could have a go and see what im doing wrong it would be much appreciated. basically i want anythign typed in other than the grade filter rules to be displayed as...

Ive spotted the error if you use it like this The problem is the bit in bold, when sGrade = anything else other the ones listed then it should be something like Null but i dont know how to code it.

Hi, The reason this is a make table query is due to the user wanting to be able to check what the "others" are if needed and the original "tblEmployees1" is the table where data is directly imported to and overwritten so we just want to keep the full titles just in case. Im struggling...

Hi All, I have an employee table (tblEmployees1) which has all employee information including their grades (sGrade). I want their grades to be converted from Manager, Senior Manager, Director etc. into M, SM, D etc in a new table. I made a table (example of it shown below) (tblGradeFilter)...

nope the query just has something like txtstartdate2 and txtenddate2 as part of an expression/code thing it doesnt actually display the dates.

thanks so much for your help and quick reply. i dont know why i didnt of that as its pretty simple. i was looking for a solution which would still work if the user closed the original form...but hopefully as this form opens on top of the original one, i dont think they would go back and...

Problem I've got a main form (frmChoosePeriod) which has a date selector option and a calendar set up so you can choose a start and end date. Note - this start and end date is understandably temporary so when you close the form these chosen dates reset to blank again. It's all coded and...