Search results

I am modifying a template from MS that's the Asset Tracker and I'm having a bit of difficulty finding out how manually place my controls on the web forms. I converted all of the web forms to client forms but the background "grid" type of placeholder mat that is there is still restricting the...

The children of table [applications] do *not* all have the same structure. that's what I'm not understanding from you. Can you explain that? I guess I'm a little bit off track now.

that sounds exactly right. what would come off of the type column though? you surely can't have field after field in the same table and leave some of them blank based on what type of item for the application is in the record. that would defeat the purpose of the DB, no?

I'm terribly sorry, as I keep forgetting that you guys always request specifics. I'm more of a large-scaled guy. I do apologize for that. See the new attachment, as that contains the data that you're looking for. This is what was requested, but the structure I think is off. As the...

Plog, the fields in the tables don't matter because those are just accompanying pieces of data. follow me on that? what really matters here is the structure of the tables themselves and the relationships between them. Regardless of what data is in what tables, the problem remains the same...

i'm not sure what you mean by "structures" of the lowest tables. as you can see, there are many "lowest level" tables. see the attached query for the output as an example. as you see there, for 1 customer that has only 1 location but 2 applications running inside that location, I have listed...

I've been asked to design a DB for warehouse inventory and migrations being done inside server farms. But I'm having trouble visualizing what I need for relationships so I can get the detailed info. out of it. My issue is figuring out what to do with all of the child tables that stems from the...

yeah tell me about it. :rolleyes: I would rather be mystified if you don't mind, but that is regarding Christianity. God doesn't care about coding.

See my comments on the other thread Alan. What do you think about all of this, my old friend?

all, I see a lot of requests for this operation, but apparently .DB files are so general that sometimes it's impossible? Does anyone know of an all-encompassing program that can read files like this? I believe they come in different formats and are produced by a variety of different programs...

Roku, Everything that you said is valid, unfortunately though it shows that you have not done the maximum amount of research possible. For instance, new records are NOT always dirty. If you're a good developer, yes they would be. But that doesn't necessary mean this is the case. My code...

The unbelievably long code that I've written is below. This is very pathetic, simply because VB is such a demanding language. :( There is literally no other way to do this! If closeForm Then 'CLOSE BUTTON pressed If fType = create Then 'CREATE form If Me.NewRecord Then 'NEW...

All, I have code running behind an image on a form that is used to close it. I also have code running behind the Before_Update() event. My code behind the Before_Update() event was meant to address the user navigating to a new record via the nav bar arrow button at the bottom only. Data is...

thank you Paul. That will do fine. What I'm really looking for more than anything though is advice on whether what I'm going to do is really worth the effort. The person on the other end really knows nothing at all. That includes servers, etc... So how much frustration is it to me?

All, I have to do this and I believe there is VBA code to re-link tables when needed that can be found on the web. My client needs access to everything because he will move on to another developer after this, so what I thought I would do is send him a private file that has the password for the...

Paul, I will try the preview mode this weekend as see if that is true. I thought I tried that earlier, but I will check again. Thanks. I will get back to you if I find it doesn't work.

Hello all, This is an expansion of my other thread: http://www.access-programmers.co.uk/forums/showthread.php?t=253820 My database is not designed very well at all. It's fairly small, but what I need to do is ... after you search for records, on the next form there is a button for printing...

all, My records are huge, with 2 memo fields. One memo field has the complete content of journal articles, so it's quite a lot of text. What I'd like to do is, per the title, split record data into 2 report pages each with the first page holding the summary field data and the second page...

this is incredibly useful. Although I was prepared to write a function. For the rest of you, the reason I posted this was because I was on information overload. And of course using Access as a statistical program doesn't help either. But you get paid for what you can get, and you go with the...

does anyone know a couple of equivalent pieces of mathematics to get to this in Access? Here is a link that explains a little bit about it: http://timothychenallen.blogspot.com/2006/03/sql-calculating-geometric-mean-geomean.html However, I'm having a problem with summing an entire field...