Search results

Hi All, I’ve got a problem to get a form to work properly at a distributed FrontEnd. This is what I did; I created a DB and split it with the Database Tools > Access Database command (Access 2007). I placed the BackEnd on a server and kept the FE at my computer. I tested the Fe to be...

Yeah! Many thanks to you Guus2005 and namliam, with the combined dependency I get what I wanted. Slowely, slowely I'll get the hang of this... ;) Salut!

Great! I’ll try that out.

Thanks for responding! I’m not quite sure what I need to do, actually I’m nearly lost. But if it is a different dependency that is needed I’ll play around a bit and see what gets. Did I describe the situation well so you got the picture, or is it unclear what I want out of the query...

Hi All! Is there someone who knows how to make somewhat nested query to two tables? My goal is to; Two tables which both contains dates and times should be queried such a way that each date from the first table is matched to corresponding date in the second table. What I’ve tried...

I had a night’s sleep and a morning of reading, and it got me wonder if a way to go is to; 1) Direct the green part of TableSplit.gif to tblBudget (as earlier) 2) Use some kind of query to delete the green columns 3) Perform a transpose (linear algebra) of the remaining part (red) 4)...

-Don’t know what would be the "major obstacle", convincing your boss or doing the coding or explain you how to do the coding ;) Word! :D This is so good, without your opinion I think I would have been struggling with this a long time. Thanks for all great advice. I’ll drop this for now...

Thanks for quick answer! :-D Yes, a better structure of input data (read; normalized Excel file) would make things much easier. You probably know costumers (read; my boss) are… conservative and not up for a change in routines. He and many of my collaborators have had their standards for...

Hi again Mailman and All! I’m afraid I not got the skills to work this out even with your previous help. I’ve been thinking, trying and reading in order to solve the problem but I just can’t manage. Would you be kind to read the below to see my “updated ” situation? Situation is like this...

Thanks Mailman! I'm glad you put me on the right track

Bob! Thanks very much for taking time, that saves me a lot of trouble shooting. Salute to you! :-D

Hi jerry28ph, pbaldy and All! This thread contains what I need to my project and tried to make use of it. But problems occurred... and please notice that I'm new to Access. I tried to use Me.OtherTextbox = Me.ComboName.Column(x) without success. Access complains that it can't find the object...

Hi All! I'm in a situation where I have a Excel file with a budget for a project, and I think(!) I need to split the imported (excel -> access) table into two tables. Please take at look at the attached file, where the red section is the column heading, the blue section contains info about name...

Hi HiTechCoach! I discovred a type-O negative... A misspelled formed caused the problem. I'm sorry for starting this thread, guess I got blind and since I'm pretty freash at Access I thought I needed some giudence... Thanks for your time anyway.

Thanks for your point of view! :-) For my purposes I think I've got my strucure of the database under control. Now its only the thecnical part remaining... and luckely its processing thanks to this forum. You are a helpful bunch of people :-D

Here it comes; INSERT INTO AttendanceT ( StundentID, InClass, AttendanceDate ) SELECT StudentT.StudentID, StudentT.TempAttendance, [Forms]![StudentT]![AttendanceDate] AS TodaysDate FROM StudentT; Can you see anything in the code that causes the problem? As I mentioned, when I execute this...

Hi all! I have a problem regarding a Append Query. I’m using Access 2007 and have just played around with it 2 weeks by myself. First I created a query that just appends two fields from one table to another. If I open the query in design-mode and execute it by the “Command Ribbon” it works...

Perfect! :-D I found it all thanks to you, JANR. Have a blessed day!

I followed your instructions but am still not getting it. Please take a look at the attached file where you can see that there are no packages to choose from when I try to add the reference (since you are located in Norway I hope my Swedish interface won’t disturb you much…). Would you be...

Hi chergh and JANR! Thanks for your replies, I got JANRs proposal to work. Very nice! But I’m still curious about cherghs strategy that I didn’t get the hang of… First, is it in Access or Excel the reference should be added? I guess Access. I tried to localize the path for the...