Search results

Any idea? Give me a hand on this

Hi all Assume that you have made an access database and some forms, you have split front end and back end but you keep on debuging and developing your front end naturally. To distribute easily and not have to go on every computer after every single change of front end I made as many files as...

I have a set of cells which I want to check and clearcontent cells that have 0. there is a total of 32 cell and my code is For i = 0 To flds Call CpyNum(Cells(i + jRowS, ColS), Cells(i + 2, srcCol)) 'Next Sub CpyNum(src As Range, des As Range) If src <> 0 Then des = src Else...

when you are calling the report to be open write the where condition for it

if you wanna get rid of the reprogramming all of your forms you can change the structure and make a query which joins two tables, then just replace name of the table with the name of the query in your forms, this is so fast. but if I were in your shoes I would redo things cause that would make...

how do you protect the back end database from users? when you give them front end you have to share the back end so their forms be able to update it, but meanwhile users themselves have access to the back and and are able to remove it, how do you protect the back end from manual modification?

As my code above declares I haven't used any drive letter, I just used simply currentdb and when I link tables to the backend they does not update however in link manager path are correct!!!! I need some other method to connect my database to front tend rather than "set db=currentdb"

I use this method to connect to my data base: dim db as DAO.Database Dim rst as DAO.RecordSet ...... set db=currentdb set rst=db.openrecordset(SQL) ..... and I splitted the database, but when I put that on the server it wanted to use tables on the address they were on my hard drive, then I...

Got it, it's solved

I used to use the conditional formatting on the format menu, where do you write the piece of code you mentioned? in the format property of the of the object? I tried that and couldn't make it

I want to use some functions I have in a module for data that should be displayed in a report, how should I do that? for example control source of a text box in a report is Code, but I want Code^2/10 ( the actual function is much more lengthy and calls some other functions) where should I apply...

Thanks man, you are amazing, I love you. However I knew the second method but I didn't want to make another table since the database is online and it's easier to change only the forms on front end. I used the first method and that is really helpful. I didn't follow you on formats :D haven't ever...

I have a report, but there are some equivalents for the fields I get from my table, for example type=1 means water system and type=2 means sewer system. as you can see i have added the type field in the table, I tried =iff(type=1,"water","sewer") in the control source box, but when I open up the...

Thanks, it helped a lot

I'm using access 2003 I tried to extend the string length by dim strSQL as String*2000 but it's not working yet how can I use query for opening recordset? using their name instead of strSQL? and how can I set the parameters of them? I need to get specific engineer number into the query I also...

I'm tring to get a SQL statement into a recordset but it is cutting when I'm trying to make it!!! I tried many different ways but it does not work my SQL is: strFLD = "SELECT Contractor, Add_D, Chores.Type, Code, Finished, Reserved, Engineer,C_Prove" strSQL1 = " FROM (Chores INNER JOIN Projects...

Yep I got that, but the way to check if an object is missing is: sub test(optional var as object) ..... if (variable is nothing) then ......

how can I write something at the start of a text file? I'm trying to make a log file and obviously latest actions should be on the top. I know that you can make another file and copy all the info of previous file after your desired log then replacing these files, but I want to know if there is...

How should I understand if an optional arguments which is collection is missing? as it seems when you don't pass it, that gets the Nothing and Nothing is not missing, so the IsMissing function won't work for it

This is compiler error, not run-time, it does not makes any difference where you put it?