Search results

Thanks Bob The maximize command worked, but I put the restore in the wrong location and the net effect was no change. But I got it working.. Thx!

When I open up a form the window that opens is always sized too small. If the form I am working on is full screen then the report opens full screen - that's just not a real option here. Is there a way in the code to tell it to automatically open as full screen? Private Sub Command8_Click() On...

I can give it a try... Going to be tough getting everyone to enter their time this way though... I would have thought my form entry idea would be easy to implement, that I was just missing something simple. Hmmmmmm

Plog I agree that your method would be easier to design and get to work. But as you all know - People do not like change! (Expecially those whom I work with!) Two reasons that I want to keep my input form looking like the XLS sheet 1. Avoid Changes 2. Boss LOVES paper backup to...

I've been tinkering with adding a new form to a database for user entry of weekly time distribution data. However I have come up blank on how to accomplish the form to enter data into an existing table. I've attached the form our employees fill out every week. These are then sent to me and I...

Arrrgghh... Sounded like a great idea! Just doing an update query to strip out all those brackets. BUT... Access 2000 - not sure, but I get an error running this query. Still researching this, but I think if I am reading the error messages right - Replace is an undefined function! Go Figure!

VilaRestal: I have now got a much bigger Right/Left/IF statement to write if you wanna help! :D Personally I'm putting this one on the back burner for next week. The query you helped to write links with a query that gives me the list of stock numbers required for any specified part. The...

Plog - while I understand what you are saying I sort of disagree - at least for my application here. Each stock number is it's own unique item. Sure, all like items are grouped together - like in my example all 4725 parts are SMT resistors and all 4725-02 parts are THICK FILM CHIP SMT...

LEFT or RIGHT functions! Arrgghh! I knew I was forgetting something! Thanks VilaRestal!! Your code worked like a champ!

I'm working with an inventory control database. I have a query that runs just fine that will give me a running balance for each item in inventory. That query's output is just two columns; Stock Number and On Hand. (sorted by Stock Number in assending order...) Now I need to further modify the...

I wanted to post this here to see if this has ever happened to anyone ... I just don't understand how it could happen; based on what I know of Access that is. I created a quick query to compute the number of labor hours expended against a particular expense account. This ran over a 2yr time...

I have an inventory database that I would like to automate a little better but my attempts have not been working as expected. To start; I have a table with a list of parts that are consumed from inventory any time I build a widget. The table lists the part number, location, and quantity...

I originally started this question in the Tables forum here but the more I worked on it the more I thought it should be a query issue. I had created a form to enter information into a table using the table alone, but I wanted one field in the table to be a combination of four other fields of...

I thought maybe I had my answer. Instead of the form using the actual table, use a query to do the work. In practice this was working. My query uses all the fields of the table, but on the RenterID field I used an equation to fill in the information automatically like I was wanting to do. As...

Is it possible to enter information into a table (either on a form or directly in a table itself) so that once you move to the next record or preferably move from one field in the table to the next; a separate field in the table is automatically filled based on a formula? For Example - I am...

jDa You did it... :D Thanks! My Renter table had an auto-number field that I set as the primary key. However, I was linking the RenterID fields between tables. I went back and set the RenterID in the Renter table to my primary key and now all my relationships between tables have changed to...

jDa Thank you for the information. It's great to confirm what I am planning is correctly set up! Anyone have any ideas why - on a sample database I download relationships can be and are set up as a 1 to many - but on my database I cannot do that. The only thing it'll let me set up is an...

Been a busy couple days at work and haven't had much time for this project... Dave; Normalizing - this is exactly why i want to start here versus from scratch by myself. But I am running into questions/issues already! :D Mostly along the lines of storing 'redundant' data in tables. For...

Thanks Alan; I've bookmarked the site and already found a useful bit of help there. Going to have to read up on relationships some; but I'll get there!

I've worked with tons of MS Access databases over the years, but never had the opportunity to start a new database from scratch. The DBs I have worked with have all had issues and when looking for help here I have always been told that I should "Normalize" the database. Well, I want to get...