Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sniffingvixen
  • Content: Threads
  • Order by date
  1. sniffingvixen

    Basic "?" Force Excel data into a table with different fields?

    Using Excel 2003 and Access 2003. I need to import Excel files from a third party. All files consist of one worksheet (different names) that contains results from a particular survey and, therefore, has a varying number of rows (300+) and columns (100+). I'm interested in 15 columns, only a...
  2. sniffingvixen

    Nested 1-to-many relationships appropriate? codeable?

    TablesProductDetails: Primary table with a text-based primary key (ProjectID). pdProduceItems: Secondary table with an autonumber-based composite primary key (ProjectID + ProduceItemID). pdOnions: Tertiary table with an autonumber-based composite primary key (ProjectID + ProduceItemID + OnionID)...
  3. sniffingvixen

    Corrupted database/VBA module? (Have to start from scratch??)

    Please help me if you can...see thread702-1316841 for original details. Since that posting, I removed all code from the problematic form hoping that I'd be able to rewrite it. While I can properly compile the VBA project now, "Value" is still the only property available to any fields active on...
  4. sniffingvixen

    expression On Current error (Compile Error: Method...not found)

    I'm working in Access 2003. I have a form containing code that was entirely functional earlier today, but now gives me the following error when opened: This form performs the following actions in response to the following events. Actions: * changes the Enabled property of various controls...
  5. sniffingvixen

    How does "Percent" work in Format property of Number data type?

    When I try to use the Percent format for a field, I can never enter the data I want. If I enter a decimal, the field returns 0%. This happens no matter how many decimals are allowed. If I enter a whole number (3), the field returns as expected according to the format description (300%). I've...
  6. sniffingvixen

    Cascading Field Visibility (code/event reference problem?)

    Hey all, I just started using Access about two weeks ago and am managing for the most part. Just now though, I've been stumped. I'm using the Function below to ensure that data entry doesn't occur out of order. In other words, additional fields aren't visible until the currently visible...

Part and Inventory Search

Back
Top