Search results

Hi, I am using this code below to retrieve the last updated time on the tablea. lbl_DataLastUpdated.Caption = "Data last updated: - " & Format(CurrentDb.TableDefs("ATM_Info").LastUpdated, "dd/mm/yyyy hh:mm") This works but the problem i have is, when i add an entry via a form or do anything...

Hi, The code below works fine, with no problem. The problem i do have though, is that i would like to keep the database on the task bar. The code below just hides the bg window for me by calling the function. But when it does it, it completely hides it even from the task bar. That is what i...

If i highlight them all, the conditional formating is disabled. All i need to do is change the background colour of the details bit in the form. But when i try clicking on details, it also fails. Thanks k0r54

Hi, I have a form with a subform that is set to continuous. I have a field [Info][.RemovedP]. What i want is if RemovedP = -2 then i want the bg colour of JUST that record to be changed. The default is blue, so what i will then get is blue bg for all the records accept if the RemovedP ='s -2...

It's still not working :( Any ideas?

Thats the thing, I have set up my groups / users and there permissions and everything, but its still allowing me to do everything. Its not asking for the user or anything?

Hi, If i want to protect everything in the database how can i do that. I dont want a password to open the database, and I only want users to be able to edit the records through my forms (without use of a password), but i dont want any1 being able to edit records manually, edit forms, or...

Hi, I was actually mistaken it is still only exporting the data from the ORIGINAL recordsource. Because i change it, i need it to pick up its new one?

Thanks Alistair Cheers k0r54

Hi, I have a subform and on that form i have a button, with that button i want to export the contents of the form to excel. It is in datasheet view and just want to export it to a file. When i load the sub form. I put the query in through a macro (for various reasons) which i think what is...

Thanks very much New it was there!

Hi, In the subform i have the layout i want with the text boxes and so on. Now i have that in the main form the sub form is fairly big, but the problem i get is the subform only displays 1 record at a time. Is there a way i can get the subform to display all the records and for it just to add...

Hi, On my form i have a text box (txt_search) and a search button (cmd_search). Now when the button is pressed i want it to go to another form (that bit is done) and display the search results (the bit that is hard). How can i get it so that when i click the button. It searches some predefined...

any ideas yet? :( still no luck

Problem solved :) Ok problem solved, one of the link fields (Line Address) needs to be a primary key

Hi, Ok, i have a really stange problem I have two tables tablea, tableb. They both have the field Line address in which is a number. However, when i have both these tables in a query and link them on line address the dataview sheet becomes locked. But if i just run a query with tablea on its...

This is the function with just the msgbox in it and the actuall function commented out Function Query_Month_Consecutive(Now, M) MsgBox "boo" ' ' Declare variables ' cnt = 0 ' MonthEquiv = 12 ' ' ' Step through the 12 months (because the array is in backwards must + 1 to now and because...

Hi, In the query field i am putting: - Consecutive Months: Query_Month_Consecutive([Report_2_group_data].[Availability]...

simple :) Thanks Jon K k0r54

Ok, I have a table with 3 fields Line address, Availability, Relevance Date Every month i put in the data given and i have back from june (so i dont actually have 12 months. At the moment i am grouping by line address(Row header) and datepart("m",[relevance date]) - (column header) and have...