Search results

Sorry to pop up like this, but I'd like to thank pr2-eugin. That link you provided gives a step by step instructions to help me do exactly what I want to do :D I just love this forum :D

Hello pr2, thank you very mych for your reply, I used what you suggested in the sql source of the query, but I'm a new error now, runtime error 3075 saying Syntax error at date in query expretion (((dbo_FOLIO.KIND)=101) AND ((dbo_FOLIO.CHKIDATE)>=#" & [Forms]![frmCleaningPlan]![DTPicker] &...

Hi guys, I'm trying to open a recordset in vba and I'm getting the 3061 runtime error,Expected 1. After some searching I found out that the problem is that I'm trying to open a recordset with a query that uses a referance to a form control. Could someone please explain to me how I should go...

Thank you very much recyan :D it doesn't give just "some guidelines" it gives me the result I was looking for :D :D P.S. I wanted to write "fldTest" don't know why I wrote "tblTest" hehe :o

Hey guys, thank you for your replies, sorry it took me so long to reply but I've had some problems that needed to be solved and I was away for a while. I've changed this Set rs = db.OpenRecordset(searchTable, dbOpenSnapshot, dbSeeChanges) to this Set rs = db.OpenRecordset(searchTable...

Hello guys, I have a problem with a query I wanna write. I have a field in a table(text field) which is like this Field ==== ABC-1 ABC-15 ABC-6 note: it's just 1 column. What'd I'd like to do is check the number after the "-" and if it's 1digit change it to the same but with a Zeoro (0) in...

Hey Bob, thanks for your reply. ignore the comments, they are written in greeklish(greek with latin characters :) ) and also those unreadable characters in the Error_Handler are just greek letters that don't copy correct."Cleaning" and "Plano" are custom functions I created The line in red...

UPDATE: I just found out that if I use my old query as "searchTable" everything goes back to working as intended..... The difference between the 2 queries is the new query uses the linked tables for souce, and the old query uses other queries as source (based on the same linked tables of...

Hey guys,sorry to post in a old thread, but I'm getting the same error so I thought I'd use this post instead of starting a new one. I use the openrecordset the way DJkarl suggested but I'm still getting the same error. And here is the wierd part. It used to work without that "dbSeeChanges" (...

Helo everyone, I have a bit a performance issue with a loop I'm using to create a report. let me elaborate a bit :) I've create a db that uses linked tables to an SQL db,which is used by an ERP program for hotel management, that a client of us uses. Because that ERP program has some problems...

Thank you very much, I'll give it a try :D

Hello Trevor, thnx for your reply There's a little problem though. Let me explain the situation. The customer that we're developing this Reports for is using an ERP program to run his Hotel. Everything works ok with that prgramm exept for the "Cleaning Reports" (don't know how else to say it...

Hello everyone, I want to create a report for the Monthly cleaning plan of a hotel. For each day, how many rooms need new sheets, how many need new towels etc. At this point I can generate a report for any given day. This could be an example of what I want to achieve ------------ Date |...

Hello everyone, it's been a while since my last post here :) I have problem that I need your help with please. I have a database with information about Hotel Rooms (reservation dates etc). I have created a form that lets you select which days you want a room to be cleaned when it is reserved...

Well my form is pretty simple actually,it only has 3 combo boxes, 1 list box ,5 text boxes and 5 buttons. Our company has 2 different shops in 2 different cities and a tech support guy can go to an other city for customer support from either of the company's "base" city.We have in the database...

Wow! I guess I took this whole "more mobile" concept a bit lighter than I should have:o I've got a lot more thinking to do -as it seems- before I move on to further development Thank you all for your input,it really was enlightening :) :) :)

I was just wondering how difficult it would be to transfer the form I've created in Access-vba- to a Windows Form Application in Visual Studio. I've created a form for a database that we have in our company that calculates for you the cost for a chosen route. It'll be used by our tech support...

Hello guys, I have a database of this form: tblDestination(id,Destination) tblDistance(Destination_id,Distace_From_Home) Destination_id is a FK that references the id of the "tblDestination". I have created an unbound form, for this db, called "frmStops" and in this form I have a combo box...

Hi guys, I have a DB that I store the ranking of several sites around the world using data I've gathered from Alexa (http://www.alexa.com) I have 3 tables in my DB Country(ID, Name) Rank(Country_ID,Site_ID,Rank,Rank_Timestamp) Site(ID,Name) I want to export data about the rank to create some...

Me.table5_combob.RowSoursce="SELECT Table_5.* " & _ "FROM (Table_5 " & _ "INNER JOIN Table_4 ON Table_5.parent_id=Table_4.id) " & _ "INNER JOIN Table_3 ON Table_4.parent_id=Table_3.id " & _...