MS Access, modifying combobox data type -


fairly new ms access (been @ 6 or 7 months , pretty self taught, bow @ alter of google , stackoverflow lot) , working on form database allow user create reports , dictate want in report.

how it's set user has 1 list that's pre-populated , doesn't change select whether report show projects happened during fiscal period, non-project related trips (we'll call them npts now) happened during fiscal period, or project series.

the second list (also prepopulated , unchangeable) activates if first or second item in first list selected. allows user select fiscal period , gives options of either: fiscal year, fiscal quarter, month, or year-on-year comparison.

once item in both of lists selected populates list of 1 or 2 comboboxes options based on what's available in table it's pulling from.

the first combobox populated , visible, it's populated alters. if fiscal year, fiscal quarter, month or year-on-year options selected first combobox populated available fiscal years, , if project series option selected it's populated list of series names.

there second combobox isn't relevant question i'll leave details out.

my problem comes first combobox. when open new instance of form no data type assigned combobox let's user wants create report projects in fiscal year , he/she selects fiscal year in combobox changes mind , decides report project series. when go try , select project series name in combobox populated fiscal years earlier error message pops stating you're trying input text numeric data type field.

so question is, there way programmatically change allowed data type first combobox in afterupdate sub of first list?

here's example of have first list afterupdate sub (rptbytype first list):

me.combobox1.rowsource = switch(rptbytype = project, _ "select distinct proj.fiscyr proj order proj.fiscyr desc;", _ rptbytype = trips, "select distinct npt.fiscyr npt order npt.fiscyr desc;", _ rptbytype = projseries, "select distinct proj.seriesnm proj;")

and again fiscyr in integer format, while seriesnm in string format, combobox1 not bound field


Comments

Post a Comment

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more