smmkaythebear

- friends
46 link karma
212 comment karma
send messageredditor for
what's this?

TROPHY CASE


  • One-Year Club

reddit is a source for what's new and popular online. vote on links that you like or dislike and help decide what's popular, or submit your own!

I want to create a database which reads in fields from differently formatted files, what's the best way to go about this? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

Not really. Also, this is the first time I'm programming in ADO/DAO. So I'm a bit clueless with all these things.

More specifically, I'm hoping to learn more about:

  1. Spec Files and auto-imports (I've been reading forums and sites but I haven't found a good source yet. Any suggestions?)
  2. populating a field in vba to with user-specified content (I've been looking at

    Dim db As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field

tdf.Append tdf.CreateField("NewField") Set fld as

Set db = CurrentDb()
Set tdf = db.CreateTableDef("NewTable")
Set fld = .CreateField("NewField", dbText)
fld.DefaultValue = "user-specified content"
fld.Fields.Append fld

But this hasn't been beneficial...

Any advice?

Thanks

I want to create a database which reads in fields from differently formatted files, what's the best way to go about this? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

That's exactly what I want. I don't know how to execute

You can set up the data mapping using File>GetExternalData>Import, then Advanced... and build an import spec which you can use later in your VBA code

though

I want to create a database which reads in fields from differently formatted files, what's the best way to go about this? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

Sorry, concise and direct explanations are not my forte.

I have 3 separate files I want to import into a common database but the field names in the sources are different. I will be sweeping a folder for the files, so tapping into the source of these files is not critical.

The 3 files all have personal information related to an item a user has, namely title, length of possession, location where the item was purchased, title of the item, color, size, and etc. The reason why there are 3 separate formats of the same information is because they're from 3 distinct systems, each with their own unique field naming conventions.

What I want to do is:

  1. Autoimport files at the start of this database by sweeping a folder as text files
  2. Create a form that I can open at the start of each workflow that lists all the imported tables within a combobox
  3. When I select a table within the combobox, vba code will read-in the table's field names
  4. Then, if I click a command button, the selected table's fields will be renamed with output file's "standard" field names and saved as output files.

Essentially, I want the code to read in a table's fields, take fields from that table that are also in the output table, save it in output table format, and export out the output table. One another thing is that the output table always has a static count of 9 fields. So, if there are fields in the output table that don't match to the imported table's fields thoase fields should be populated with null values. I would typically do this with a predefined table and append queries, but I think it would take too long and I don't know how to account for different field names

Is this anyone's favorite thing about this time of year? by The_Abdicatorin Drugs

[–]smmkaythebear 0 points1 point ago

wait, i thought recent studies have shown that brain functions aren't as highly localized as Mr.Gage's case.

Men's minimalist work shoes for small feet? by AceOfJestersin BarefootRunning

[–]smmkaythebear 0 points1 point ago

Try these. I wear this to work every day and I haven't been disciplined... yet: http://www.vivobarefoot.com/us/kids/ra-kids-14.html

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

It comes from a vendor which uses its own secret database

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

oh... I had no idea. thanks! does this mean i necessarily need to have the database set up before running the query or is it possible for this query to create the table and the database it will householded under?

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

random copies of the subsets. Typically, I do this by

Select TOP Control_Count * FROM Subset1 where certain criteria Order by Rnd([Field]);

I need to develop database via Access but I don't know DAO... Help? by smmkaythebearin Database

[–]smmkaythebear[S] 0 points1 point ago

I also want to hold out control groups from each of the 25 subsets. How do I do something like this? Do I need to use one of tabledefs? I've had 0 formal training in Access and have not found good source which explains DAO's in detail...

I need to develop database via Access but I don't know DAO... Help? by smmkaythebearin Database

[–]smmkaythebear[S] 0 points1 point ago

I think that's the ideal solution in the end but due to my current team's skill set, myself included, Access is the only viable option

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

It will be massive. I would estimate to be roughly 1million rows which I will use with a separate server

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

What I need to do is create a control group and a target from from each of the 25 subsets. Then, to archive them, export them out to a single folder, where I can aggregate with other lists.

I also want to hold out an x % of each 25 subset and I'm thinking in order to achieve this, I need to write some code which involves TableDefs. However, I haven't found adequate resources to achieve this yet.

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

I wasn't aware I could use a query make a table in a separate database from the one that is running the query. How do I do this?

I need to develop an automated database via Access but I don't know DAO very well... Help? by smmkaythebearin MSAccess

[–]smmkaythebear[S] 0 points1 point ago

In the end, 25 datasets need to be queried differently, depending on each's selection criteria, then rolled up into a 2 tables and exported as text, xls, or csv files to a single location. Ideally, I would have error logs, timer, and record-keeping functions to track the progress of each.

The ultimate output can be produced sequentially and no single database needs to contain all the datasets in a single location. That is the reason why I prefer to have a Master database kick off 25 databases in succession, since, that way, I could minimize data corruption issues. However, I don't know the API's to acomplish this task or if it's even possible in Access.

Lastly, I would very much like to start with a single form in the Master database and use it to determine which of the 25 subsets to run at any given time. Then with a click of a button, I would kick off the process and review the error logs or output logs.

Ricky Williams by custerb11in trees

[–]smmkaythebear 0 points1 point ago

too bad harbraugh wanted to make flacco a passer and didn't use rice and williams on the back. they would've torn shit up

TIL that the Tank Man image is "Virtually unknown within China" due to censorship by tombabanin todayilearned

[–]smmkaythebear 18 points19 points ago

they put more faith in their collective system than individuals. as a result they tend to side with numbers.

Art made with a single piece of paper by moosetracks24in Art

[–]smmkaythebear 2 points3 points ago*

i agree with everything you just said, but from my point of view, the skeleton seems more symbolic of death or the next state of our physical selves, a perspective/perception which we may never have. As if a man had died and the his soul was peering down at his remains, pondering.

The piece says to me: How would you look back on your life?; Or, Have you lived?

Zarathustra (Nietzsche) on Chasing vs. Attracting by gmolinariin seduction

[–]smmkaythebear 1 point2 points ago

This is how is how I first read Thus Spake Zarathustra- chapter by chapter with Jung's analysis. It was a mind blowing during my freshmen year in college

First attempt at stainglass by whatistugin Art

[–]smmkaythebear 1 point2 points ago

oh, and happy new year!

First attempt at stainglass by whatistugin Art

[–]smmkaythebear 1 point2 points ago

i'm at a loss for words; it's absolutely stunning. where did you learn this craft?

I like trying photorealistic portraits (colored pencils). Here's a work in progress... by re1in Art

[–]smmkaythebear 2 points3 points ago

Mind if I ask how many you've sunk into this single pic? I typically sacrifice 1 or 2 accidentally from dropping them

view more: next