Recent content by MrAustin

Right you are, NPUser. Whoops!

I don't think that is quite what mafhobb is looking for. The OP wants the "new entry" portion of a datasheet view to appear at the top of the list of entered records. To my knowledge this portion is always at the bottom, no matter what. You could have text boxes which the user fills out to...

I tried searching, to no avail. I've attached pics to represent my issue a bit clearer. I have a form that I want to be my switchboard, but my clients all have different resolutions, and this is where I run into the problem. I want the switchboard to not only be maximized, but appear...

Hi all -- I have a worksheet that needs to be parsed for certain information, so let me just explain how the sheet is setup first. The sheet is used to analyze performance metrics, which run along the columns, among category groupings that run along Row A. What I have been charged to do is to...

Thanks for the quick reply! I'm new to the With RS syntax ... how do you go about adding a WHERE clause? Is there a way to just write out a SQL statement and run that statement from excel? Maybe some pseudo-code to get my brain juicing? Thanks again!

Hello everyone -- My boss has a project for me, and while they seem to get the impression that I know everything about access and excel, this is simply not the case. So major brownie points for me if I can get this working. I have an access system setup right now to handle vendor disputes for...

Good afternoon all -- I have created a macro that will export fields from Access to a formatted Excel spreadsheet so that it can be printed and mailed to one of our vendors. They are VERY specific about the format of this form. At any rate, this works when someone is entering data on a...

Hey all, If I have a user login at the beginning of my access program, how can I later access their username, password, security level, etc? I would have thought I just stored it in a public variable at login time, but this doesn't seem to work. Any help? Thanks!

Hi everyone! I have a very basic form question -- I have two text fields and a button, all on the same "line" horizontally, and the two text fields are search fields. The button is a submit button. My question is, how to program the two text boxes so that when the return or enter button is...

For some reason I am having trouble visualizing this. I am new to database design, so to some it probably makes perfect sense, but to me I can't "see" it, ya know? I'll take a look back when I'm less tired. Thanks again!

Hello everyone! I am writing a database for my employer, and they would like this to store employee information. With Sarbanes Oxley out there now, they need to keep track of who has read access to programs, and who has write access to programs. My question is this: What method would you...

Good afternoon everyone, I have a header table, which contains the totals and collectives from a credit memo for my company, and also a detail table, which collects line item details from each credit memo. What I need to do is design a form in which the main form holds the header info, then a...

Hi all, I am using the following code on a command button: Private Sub cmdPrintTicket_Click() DoCmd.OpenReport "rptPrintTicket", acViewNormal, , "[tick_id] = " & Me.tick_id.Value End Sub But when I run the code, it prompts me for "cust_id" which is another field on the form, and in the...

Thanks Doc, I'm unfamiliar with using recordsets, but I'm sure with just a little research I can find the answer, as from what I've heard that is the more efficient way to do this (and it's going to have to happen a LOT throughout the course of parsing this file). Thanks again!

Hi all, I am writing an application to parse a text file, and each portion contains header information, then detail information. I need to relate the detail info the header info, and I want to do this by storing the primary key of the header autonumber field into a related field in the details...